Add Data To Pivot Table

R

Robert Walker

I made a report, requested by our sales reps, that
included sales figures for various customers and
territories over the last few years, showing month
to month totals per rep. But ...

How can I update the report on a monthly basis now?
Instead of having to go back and run the whole report
over again each month, I mean. I just want to be able
to add in the next month's totals to the figures already
in the previous report, but I see no way to 'undo' the
previous setup to add in the new stuff, or merely combine
the new figures with the old.

What am I missing? Any help appreciated.
 
N

Nick Hodge

Robert

A possible answer already in the Excel group...no need to multi post

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top