If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|