finding the last row in another worksheet

E

edg

I have an extremely volatile worksheet - membership names, addresses and
other data. I need to keep statistics on numbers of criteria. Since I am
always adding and deleting rows, my statistics ranges have to be updated
manually. They are on a separate page. Is there any way to find the end of
the sheet so I don't have to constantly change my statistics ranges?

Thank youl.
 
A

ART

Yes,
you can go to that sheet and press Ctrl+End
That will take you to the last used cell in that sheet
Ciao
 
B

Bob Phillips

Use a dynamic named range. On the other sheet add a name,
Insert>Name>Define... of

=OFFSET($A$1,,,COUNTA($A:$A),1)

and then use it on the first sheet

=SUM(myRange)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top