Hi,
I hope someone can help. (Firstly I will give a bit of info on the type of thing I am working on) I have a workbook where on a monthly basis I enter the details of all invoices issued for the company, there are seperatate tabs for each month. Each page is laid out the same however some months will have, for example, 20 entries other will have 40.
Hoe can I create a pivot table that will enclude all of the tabs? (I can manage to do it for one month but ideally I would like a summary for the year to date that can be updated every month)
Many thanks in advance for any help given.
Jen
I hope someone can help. (Firstly I will give a bit of info on the type of thing I am working on) I have a workbook where on a monthly basis I enter the details of all invoices issued for the company, there are seperatate tabs for each month. Each page is laid out the same however some months will have, for example, 20 entries other will have 40.
Hoe can I create a pivot table that will enclude all of the tabs? (I can manage to do it for one month but ideally I would like a summary for the year to date that can be updated every month)
Many thanks in advance for any help given.
Jen
