I have a summary table in sheet 1 that needs the totals from other sheets in
the workbook. the totals on the other sheets totals are on the last row of
the sheets however these rows constantly change.
Is there a way i can tell exceel to look at column b in sheet 2 and always
look at the last row for the amount?