Multi-sheet linking
 

I hope this problem belongs to this group!

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

Multi-sheet linking
 

1. I suggest to put the subsheets's totals at the top of the pages (above
the data instead of below the data), thus positions are fixed and are less
sensitive to on sort or insert/delete. (It also makes the consolidation
sheet easier to maintain)

Next thing to check is that the sheet's formulas wont be meaningless after
the data on the sheet is (re)sorted. Most sumproduct/sumif's can easily be
made bulletproof)


PrevMonth Cumulative = sheet1!c3
ThisMonth Period = sumproduct(n($a$10:$a$700=4);c$10:c$700)
ThisMonth Cumulative = sum(c$1:c$2)

capisce? :)


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Abir" wrote:

I hope this problem belongs to this group!

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