Excel: 12 months+ 36 pivot = 48 sheets...can I simplify it?
I agree with the advice to download the info to one sheet and then use
the pivot tables to sumarize the data. To add the month and year
should not be so difficult you can write it in one celland then COPY
and PASTE down. That should not take much more than a minute to do!
The Formula is also a good solution one column for year and anoter for
month..
=year(cell)
=month(cell)
Copy and Paste.
Good luck with your secretary and have a Happy New Year!
|