Ohh, I also went back and realized that you will be doing a pivot on several
spreadsheets, not just one... If you use the example that I described before,
then you can modify your "routine" to encompass more than one spreadsheet.
If every spreadsheet has the exact same columns, or at least the two columns
in question next to each other, with a third that ALWAYS has data in every
cell, then you can do a pivot table off of multiple spreadsheets. Each week
that you add a worksheet, you can go back into the wizard (Right clicking on
your pivot table.) and add the new worksheet into your pivot table.

Seriously there is help out there on pivot tables, they are not too
complicated to use, but they can be great tools for data analysis which is
what you are basically performing. And think of it.. You'll be a big hero.
:) A really easy solution to what looks like a difficult task.


"steven_senko" wrote:


okay, maybe I should rephrase, lol, I'm a novice excel user, sorry if I
seem dumb but I don't quite understand what you're trying to explain.
I understand the concept but not how to put that concept in place.


--
steven_senko
------------------------------------------------------------------------
steven_senko's Profile: http://www.excelforum.com/member.php...o&userid=30417
View this thread: http://www.excelforum.com/showthread...hreadid=500849