Link to home
Create AccountLog in
Avatar of sergeant_time
sergeant_time

asked on

Create List(data validation) with Pivot Table

Hello,

I am trying to mimic the "PivotMulipage" found @ http://www.contextures.com/PivotMultiPagesChangeAll.zip. My goal is to create a list using data Validation. The user will  maka a selection based on two criterias ( Name and Day) and analyze data from the selection. I attached a spreadsheet with the Pivot Table. I also included the VBA code that was utilize as a example. I will be creating pivot charts also.
weekly-historical.xlsm
Avatar of rsomasundar
rsomasundar
Flag of India image

ok. It seems this pivot is working according to the day and name selection.
Is there any question on this...
Avatar of sergeant_time
sergeant_time

ASKER

I was trting to mimic the above site mention in my post. On this site she used a data validation (list) to manipulate the pivot table. I tried copying her VBA code but failed to get it to work correctly.  http://www.contextures.com/PivotMultiPagesChangeAll.zip
ASKER CERTIFIED SOLUTION
Avatar of TommySzalapski
TommySzalapski
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account