- Joined
- Sep 22, 2009
- Messages
- 1
- Reaction score
- 0
Hello
I am creating a summary sheet in a workbook. I need to display all the worksheet/tab names in column A starting with cell A2. I am able to display the current sheet in a single cell using one formula, but i need a formula that i can drag down the column and it will list all the worksheets in the workbook. Each worksheet is the first initial and last name of employees. In addition, the sheets listed in column A will act as a index for pulling data. I have not been able to figure this out. My experience in excel does not go this far. Can anyone help? Thanks.
I am creating a summary sheet in a workbook. I need to display all the worksheet/tab names in column A starting with cell A2. I am able to display the current sheet in a single cell using one formula, but i need a formula that i can drag down the column and it will list all the worksheets in the workbook. Each worksheet is the first initial and last name of employees. In addition, the sheets listed in column A will act as a index for pulling data. I have not been able to figure this out. My experience in excel does not go this far. Can anyone help? Thanks.