Extract Worksheet Title/Refence
 

I have a huge list of worksheets, I need to check that I have captured them
all against our product list. Is there a way to extract every worksheet to
make a list and compare?

Extract Worksheet Title/Refence
 

Hi,

So you have 1 workbook with a huge number of sheets and you want to workshet
titles and references? What does worksheet references mean?

To extract the name of all the sheets in a workbook to a column A in sheet1
use a macro

Sub mySheets()
I=1
For each sh in Worksheets
Range("A1").Offset(I,0) = sh.Name
I=I+1
Next sh
End Sub

(untested)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Ludim" wrote:

I have a huge list of worksheets, I need to check that I have captured them
all against our product list. Is there a way to extract every worksheet to
make a list and compare?