How to refer to tab names?

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

Jacob Skaria

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ref Formula 4
Consolidate by range names which represent worksheet tab names 4
how do i link the names of tabs in a workbook to a summary page? 1
Summary sheet from tab names 3
Sheet tab names change automatically 3
FINDING A NAMED TAB 8
Freeze Formulas - Replace Worksheet 5
Move data on multiple tab to one 2

Top