How to refer to tab names?
 

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.

How to refer to tab names?
 

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"))

--
Jacob


"Rj" wrote:

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.