Hello
I have a summary page which is looking up to many pivots to bring through performance by month. The Summary page has a filter where you can select a department and all the data in the summary will update.
One of the tables in not a pivot is it just a table of data and I am struggling to automate it to appear in the summary page,
Example;
Department is a filter where you select the department
The month and years are along the top e.g.
2019 2019
Mar April
the data items are down the left hand side.
I need to look up the filter, the month and year and being though the relevant data from the table which is in another worksheet
Does that make sense?
Any help appreciated
Katherine
I have a summary page which is looking up to many pivots to bring through performance by month. The Summary page has a filter where you can select a department and all the data in the summary will update.
One of the tables in not a pivot is it just a table of data and I am struggling to automate it to appear in the summary page,
Example;
Department is a filter where you select the department
The month and years are along the top e.g.
2019 2019
Mar April
the data items are down the left hand side.
I need to look up the filter, the month and year and being though the relevant data from the table which is in another worksheet
Does that make sense?
Any help appreciated
Katherine