Displaying the name of a worksheet in a cell ?

  • Thread starter Thread starter NickTheBatMan
  • Start date Start date
N

NickTheBatMan

I have a workbook with 18 worksheets in it.
The first worksheet is to display the contents of all the other
worksheets as a single reference so that we can more easily look for
duplication.

I would like to add a formula in the first column that is going to
display alongside all these entries the name of the worksheet that
each row has come from... there are currently nearly 1000 rows...

Hope someone follows and can help me ?
 
I have a workbook with 18 worksheets in it.
The first worksheet is to display the contents of all the other
worksheets as a single reference so that we can more easily look for
duplication.

I would like to add a formula in the first column that is going to
display alongside all these entries the name of the worksheet that
each row has come from... there are currently nearly 1000 rows...

Hope someone follows and can help me ?
Click to expand...


After all that, no need thanks as I've found a MUCH easier answer to
it all...
 
Back
Top