The file has two worksheets.

Sheet one will be sorted and Sheet two will remain static.

Column F in Sheet two is reading the values from Sheet one in column F (you
can see the forumula in column F sheet 2) (For Ex: =SUM(Sheet1!F2)

For example, if I sort sheet one (any column) then Sheet 2 does not remain
static and the integrity of the data is lost. What happens is Sheet 2 column
F will change but the other columns in sheet 2 don't change and the integrity
of the data is lost.

If you like I can email you the file.

Hope that makes sense.

Please let me know how to resolve this.

Thanks
cmckeag

The file has two worksheets.

Sheet one will be sorted and Sheet two will remain static.

Column F in Sheet two is reading the values from Sheet one in column F
(you can see the forumula in column F sheet 2) (For Ex:
=SUM(Sheet1!F2)

As an aside, "SUM" is doing nothing here since there's only one number in
the sum. I'd suggest simply =Sheet1!F2 for clarity.


For example, if I sort sheet one (any column) then Sheet 2 does not
remain static and the integrity of the data is lost. What happens is
Sheet 2 column F will change but the other columns in sheet 2 don't
change and the integrity of the data is lost.

It's often the case that there's a "key" column that identifies the row
uniquely; for example, an account number or a part ID or a date or
something like that.

If your spreadsheet has a column like that and it appears in both sheets,
then read about the VLOOKUP function in Excel's built-in Help. Used in
Sheet2!F2, it'll find the value in Sheet1 column-F that has the same key
value as the current row.

For example, if the key column is A in Sheet1 and B in Sheet2, try the
following in F2 and copy down:
=VLOOKUP(B2,Sheet1!A:F,6,FALSE)

Modify to suit.

*******************************

"MyVeryOwnSelf" wrote:

The file has two worksheets.

Sheet one will be sorted and Sheet two will remain static.

Column F in Sheet two is reading the values from Sheet one in column F
(you can see the forumula in column F sheet 2) (For Ex:
=SUM(Sheet1!F2)

As an aside, "SUM" is doing nothing here since there's only one number in
the sum. I'd suggest simply =Sheet1!F2 for clarity.


For example, if I sort sheet one (any column) then Sheet 2 does not
remain static and the integrity of the data is lost. What happens is
Sheet 2 column F will change but the other columns in sheet 2 don't
change and the integrity of the data is lost.

It's often the case that there's a "key" column that identifies the row
uniquely; for example, an account number or a part ID or a date or
something like that.

If your spreadsheet has a column like that and it appears in both sheets,
then read about the VLOOKUP function in Excel's built-in Help. Used in
Sheet2!F2, it'll find the value in Sheet1 column-F that has the same key
value as the current row.

For example, if the key column is A in Sheet1 and B in Sheet2, try the
following in F2 and copy down:
=VLOOKUP(B2,Sheet1!A:F,6,FALSE)

Modify to suit.