View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Stan Stan is offline
external usenet poster
 
Posts: 10
Default 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!