Hi,
I have two worksheets containing data with each column totalled seperately
in the last row, also, each sheets totals are linked to the other sheet so
that the two totals can then be added together. I regularly have to add or
delete a row or rows from one or the other sheet which then throws the link
out. Is there a way I can make each sheet total after removing/adding rows
without having to change the link formula each time?
Thx
Kev