I am using the code below to control a series of Data Validation Menus which link to a Pivot Table on a separate worksheet.
The project has now grown and I need to set up three separate Pivot Tables with three separate worksheets using independent Data Validation Dropdown menus, one to control each Pivot Table.
The code is currently universal. How do I change this code to make it Worksheet specific, eg. if my first Pivot Table is on a worksheet called NorthPivot and my Data Validation Menus used to control the Pivot Table on the NorthPivot Sheet are on a worksheet called North, which lines in this code do I need to change and what do I need to change them to so they are specific to this worksheet only.
I will have another pair of worksheets called 'MidlandsPivot' and 'Midlands' and a third pair called 'SouthPivot' and 'South'. All three pairs need to be indpendently controlled.
Many thanks for any help, it is gratefully appreciated...
Bookmarks