Thread: Referencing Sequential Sheets.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
the-big-john[_2_] the-big-john[_2_] is offline
external usenet poster
  
Posts: 5
Default Referencing Sequential Sheets.
T. Valko's post was most helpful. I ended up using something along the lines
of:
=COUNTA(INDIRECT(A2&"!A2:A50000"))
I knew about the Indirect function. I didn't know about the ampersand and
quotations.
Thanks to all.
Reply With QuoteReply With Quote