How to refer to tab names?

  • Thread starter Thread starter Rj
  • Start date Start date
R

Rj

Hi all,

I have around 50 tabs (worksheets) to deal with in a workbook. I have to
come up with a summary in another worksheet that lists down the tab names and
the total items in each tab. So, could anyone please help me figure out on
how:

1. to refer to each of the tab names (i.e Food, Place,and etc.) and place
them in a cell in another worksheet?

2. to refer to each count of the items at the end of the list for each tab?
How can I do it without having to key in them individually?

TQ.
 
Use INDIRECT() as below.

'the below will refer to cell B10 of tab name specified in cell A1
=INDIRECT("'"&A1&"'!B10")

'the below will get the count of integers in ColA of tab name specified in
cell A1
=COUNT(INDIRECT("'"&A1&"'!A:A"))
 
Back
Top