Should I use Pivot Table or something else?

[Tina W.]

Hi all,

I'm generally a novice at using excel, so at the moment I'm stumped at
figuring out exactly how to do what I need. Here's the problem -

I'm looking at summarizing a small portion of data that is from a larger set
of data. This data is updated and added to each week (meaning there is a new
column of data for the latest week). My solution at the moment is to use a
pivot table and filter down to what I need.

Question: But how do I just add the new weeks of data without recreating my
pivot table?

Also - There is a couple of groupings that I would like subtotals for. Is
there a way to select just a couple of rows of data in the pivot table and
subtotal that?

Or should I be using something completely different? Right now I have two
fields that form the rows, so the number of rows will likely change (so I
don't think just using lookup would work well for this).

Thanks for any help you can provide.

Tina