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