change the source

I want to change the source for my 'PERMUTATIONS COUNT' pivot table to range K5:K14 on the DTA sheet
permuta_count.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
I replaced the pivot table with formulas.
29119954.xlsm
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin
sorry

i get lost with this
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
i get this after press the buttons

one button is missed

z3333333333.PNG
0
Determine the Perfect Price for Your IT Services

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

Martin LissOlder than dirtCommented:
I removed the wrong button in the other workbook.
29119954a.xlsm
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

i  see the  same as the fisrt

is not any button to move the one digit count data to the column L?
0
Martin LissOlder than dirtCommented:
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?
0
ADRIANA PACCOUNTING ASSISTANTAuthor 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
0
Martin LissOlder than dirtCommented:
I think all you need the 'Clean Count Sheet' button is to clean columns 'A' to 'G' on the COUNT sheet.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
ok

will be easy but the new data to be count ?
0
Martin LissOlder than dirtCommented:
will be easy but the new data to be count ?
I'm not sure what you are saying/asking but try this,
29119954b.xlsm
0
Roy CoxGroup Finance ManagerCommented:
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
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Thanks  Roy Cox
0
ADRIANA PACCOUNTING ASSISTANTAuthor 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
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Roy Cox

how can be  show the
Analyze Tab of the PivotTable Tolls ??
0
Roy CoxGroup Finance ManagerCommented:
Click in any PivotTable and the tools appear in the Ribbon
0
Martin LissOlder than dirtCommented:
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.
0
Martin LissOlder than dirtCommented:
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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great Job !!

Best Experts !!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VBA

From novice to tech pro — start learning today.