Thread: How to reference the current total, when it could be Cell H9 or H2
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gina[_2_] Gina[_2_] is offline
external usenet poster
  
Posts: 49
Default How to reference the current total, when it could be Cell H9 or H2
I have a workbook with several worksheets. Each of these worksheets has a
column (H) that has a running total. This total could be found in cell H3 or
H32, but the highest row# is always the current total.

Which function could I use in Sheet1 to return the current total of Sheet2?

Thank you !

Gina
Reply With QuoteReply With Quote