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.
|