Multi-sheet issue

I have several sheets of budget numbers that are linking
from one sheet to another. In linking several sheets by
pulling totals from one sheet to create other totals in
another sheet we seem to have lost the ability to sort
without changing the totals on the endpoint sheet. This
happens because we're linking to the source sheet using
the Sheet and Cell info and the sort places the totals in
different cells than the ones named in the second sheet.
Anyway to deal with this problem? Thanks. Koz

if the leftmost column has some identifying value, you could use the vlookup
function to find the appropriate row and return the value.

--
Regards,
Tom Ogilvy

Abir wrote in message
...
I have several sheets of budget numbers that are linking
from one sheet to another. In linking several sheets by
pulling totals from one sheet to create other totals in
another sheet we seem to have lost the ability to sort
without changing the totals on the endpoint sheet. This
happens because we're linking to the source sheet using
the Sheet and Cell info and the sort places the totals in
different cells than the ones named in the second sheet.
Anyway to deal with this problem? Thanks. Koz

Thanks Tom. Appreciate it. Abir

-----Original Message-----
if the leftmost column has some identifying value, you
could use the vlookup
function to find the appropriate row and return the value.

--
Regards,
Tom Ogilvy

Abir wrote in message
...
I have several sheets of budget numbers that are linking
from one sheet to another. In linking several sheets by
pulling totals from one sheet to create other totals in
another sheet we seem to have lost the ability to sort
without changing the totals on the endpoint sheet. This
happens because we're linking to the source sheet using
the Sheet and Cell info and the sort places the totals
in
different cells than the ones named in the second sheet.
Anyway to deal with this problem? Thanks. Koz



.