change the source

ADRIANA P
ADRIANA P used Ask the Experts™
on
I want to change the source for my 'PERMUTATIONS COUNT' pivot table to range K5:K14 on the DTA sheet
permuta_count.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I replaced the pivot table with formulas.
29119954.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin
sorry

i get lost with this
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
i get this after press the buttons

one button is missed

z3333333333.PNG
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I removed the wrong button in the other workbook.
29119954a.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

i  see the  same as the fisrt

is not any button to move the one digit count data to the column L?
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I don't know what you mean. By "one digit count data" do you mean the DTA sheet column 'K'?

Just now while trying it out I clicked the 'Clean Count Sheet' button which destroys everything. Do you need that button?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
do you mean the DTA sheet column 'K'?

yes


Do you need that button?

yes  !!  to put new data as needed

need an button to copy the data from column K DTA to  L count sheet
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I think all you need the 'Clean Count Sheet' button is to clean columns 'A' to 'G' on the COUNT sheet.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
ok

will be easy but the new data to be count ?
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
will be easy but the new data to be count ?
I'm not sure what you are saying/asking but try this,
29119954b.xlsm
Roy CoxGroup Finance Manager

Commented:
You can change the source by using the Change Data Source in the Analyze Tab of the PivotTable Tolls.

range K5:K14 on the DTA sheet
has no data though
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Thanks  Roy Cox
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

the way you did this solution

i don't see how the  column L in Count sheet will change

when new data is add to  Column A DTA
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Roy Cox

how can be  show the
Analyze Tab of the PivotTable Tolls ??
Roy CoxGroup Finance Manager

Commented:
Click in any PivotTable and the tools appear in the Ribbon
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
i don't see how the  column L in Count sheet will change
You requested that column 'L' be based on column 'K' on the DTA sheet. When the values in column 'K' on the DTA sheet change the values on column 'L' will change.

Solicitó que la columna 'L' se base en la columna 'K' en la hoja de DTA. Cuando los valores en la columna 'K' en la hoja de DTA cambien, los valores en la columna 'L' cambiarán.
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
In this workbook I replaced all the pivot tables with VBA code. I also changed the formulas in columns 'B' and 'F' so that everything in that column shows up as 3-digit numbers. That corrected the problem you used to have in column 'O' where some of the numbers incorrectly showed up with only 2 digits. When you click the 'Permutations' button the data in columns 'I', 'J', 'O' and 'P' will be replaced.

En este libro de trabajo reemplacé todas las tablas dinámicas con código VBA. También cambié las fórmulas en la columnas 'B' y "F" para que todo en esa columna aparezca como números de 3 dígitos. Eso corrigió el problema que solías tener en la columna 'O' donde algunos de los números aparecían incorrectamente con solo 2 dígitos. Al hacer clic en el botón "Permutations", los datos en las columnas "I", "J", "O" y "P" serán reemplazados.
29119954c.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great Job !!

Best Experts !!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial