Is there a way to link filters automatically so selecting one links the other?
Attached is a sample with what is needed under build plan tab
if possible,can someone explain how.
Thanks
Is there a way to link filters automatically so selecting one links the other?
Attached is a sample with what is needed under build plan tab
if possible,can someone explain how.
Thanks
Ok, ive found some vba code but have no idea how it works? originally supplied by DonkeyOte :
http://www.excelforum.com/excel-gene...-criteria.html
can anyone help???
If i understand your requirement correctly, if you select March in the first pivot, you want April to be automatically selected in the 2nd one?
What if someone selects April in the 2nd pivot, should the first one change to March?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Yes you are correct, exactly as i want it. Also the product want to be the same on both sides too
Thanks for looking
Any luck at solving this ???
Have been working on it....tough one to crack...will try something, if not will fwd it to the experts.
Thanks for your time. Maybe the years and months and products dont need to be in a pivot?? the lookup1 tab has all that in it?? the build plan tab just needs to look roughly the same with the 8 total products ( others may need adding later)....
How will u filter the data if you are not going to include the years and months & products in the pivot?
it was just a thought on a different approach. Any ideas on solving this??
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks