LeahNZ
09-17-2013, 03:34 AM
Hi
I have a worksheet which contains a main body section. When a Job Code is entered into A1, all cells are populated by VLOOKUP to two other sheets within the workbook.
Following from here is 3 pivot tables referenced to 3 other sheets in the workbook. All 3 tables have filters that need to be changed to match the Job code entered into A1.
So currently I need to enter the Job Code into the sheet 4 times (Copy & Paste does not work in pivot table). Is there any way I can get the 3 pivot table filters to update based on the Job Code I have entered into A1.
Note** Not sure if it matters, but the 5 other sheets in the workbook are populated via a OLE-DB excel add in for a SQL data base to an accounts system called Attache Pro.
I have a worksheet which contains a main body section. When a Job Code is entered into A1, all cells are populated by VLOOKUP to two other sheets within the workbook.
Following from here is 3 pivot tables referenced to 3 other sheets in the workbook. All 3 tables have filters that need to be changed to match the Job code entered into A1.
So currently I need to enter the Job Code into the sheet 4 times (Copy & Paste does not work in pivot table). Is there any way I can get the 3 pivot table filters to update based on the Job Code I have entered into A1.
Note** Not sure if it matters, but the 5 other sheets in the workbook are populated via a OLE-DB excel add in for a SQL data base to an accounts system called Attache Pro.