Macro to Select Pivot Table Dropdown Value Based on Cell Value in Worksheet
$10-30 USD
Paid on delivery
I have an Excel file with many worksheets (see attached picture 1), each one containing the exact same pivot table. I need a macro to tell each pivot table in each worksheet to select the value in C6 (see attached picture 2) by matching the value in cell C3.
So in the attached pictures example, cell C3 is 6463. The dropdown in the pivot table has a range of values. Based on the value in C3, the dropdown will only select 6463 and complete the pivot table across all columns accordingly.
Please note that the dropdown is in the "Row Labels" section of the pivot table.
Project ID: #7192166
About the project
Awarded to:
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards
15 freelancers are bidding on average $29 for this job
Hello sir, I am PREFERRED freelancer in excel and related skills on this forum with 200+ five star reviews. I have understood your requirement and I am ready to start the implementation immediately. Looking forward to More
Hi, I am working as software professional in IT industry from last 4 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio More
Hello, I have prepared the excel macro. I can give demo so that you can check. Looking forward for the reply. Regards, Aditya
See portfolio and reviews, contact me if interested. Thanks, __________________________________________________________
Hello sir... i guarantee you 100% satisfaction and my expertise lies in quality service and delivery on Time kindly if you wants high quality work then as soon as possible contact me. Please give me chance to prove mys More
Hello, I have seen your project. I am offering my services for this work.I can complete this task with 100% accuracy and within defined timelines. Completing the job with 100% accuracy and with punctuality is my f More
Hi, i am interseted in to do your project, i can handle it properly and on time with the help of your little guidance. Regards
Dear sir: I'm an Electrical engineer, So I have more experience in writing field via Microsoft programs while I perform all of my reports by this programs. I can perform your task as soon as you need with high accurac More