Pivot tables and data

[TimW]

I am at a loss as to how to accomplish something here.

I have a data source on the net which imports onto
SheetA!A1:Z500

This data source can have records added to it at any time,
but should not have records deleted.

Now, on SheetB!A1:E500 various columns from SheetA are
added together, with a unique identifier in column A to tie
the whole thing together.

Adjustments need to be manually made from time to time.

So that if you have this
A B C D E
1 A1 20 30 40 50

Column F-I would be adjustments that would affect the sum
of B-E. So if I enter in F -5, when they are resummed on
SheetC, it would look like the following.

A B C D E
1 A1 15 30 40 50

The problem is, when new records are inserted, the data in
the table may sort differently. How do I keep the manually
input data with it's corresponding row?

Thank you in advance.

TimW

 

[Debra Dalgleish]

You could enter the manual adjustments on a separate sheet, and type the
unique identifier in the first column.

Then, on sheet B, use vlookup formulas to return the matching data from
the adjustment sheet.