listing all names of worksheets in a workbook and listing the value of cell T6 of each worksheet

[Rocky.Paredes]

Hi - I really need some help.

I am trying to develop a macro that will:
listing all names of worksheets in a workbook on a separate worksheet
and list the the value of cell T6 of each worksheet.

The macro below will list the sheet names on a separate workbook but how do I get the contents of cell T6 of each worksheet to appear next to the worksheet name?

You're welcome to disregard the macro below and provide your own.

I really appreciate your help! Thank you.

Sub ListWorkSheetNames()
Dim Sheetnames
Sheetnames = Sheets.Count
Sheets.Add
ActiveSheet.Name = “SheetList”
Sheets(”SheetList”).Move after:=Sheets(Sheetnames + 1)
For i = 1 To Sheetnames
Range(”A” & i) = Sheets(i).Name
Next i
End Sub

 

[Marc L]

Hi,

as you get the name, you get the cell …

Sub ListDemo()
    C& = Worksheets.Count
    Worksheets.Add , Worksheets(C)
    ActiveSheet.Name = "SheetList"
 
    For R& = 1 To C
        Cells(R, 1).Value = Worksheets(R).Name
        Cells(R, 2).Value = Worksheets(R).[T6].Value
    Next
End Sub

 

[Rocky.Paredes]

Hi,

as you get the name, you get the cell …

Sub ListDemo()
    C& = Worksheets.Count
    Worksheets.Add , Worksheets(C)
    ActiveSheet.Name = "SheetList"
 
    For R& = 1 To C
        Cells(R, 1).Value = Worksheets(R).Name
        Cells(R, 2).Value = Worksheets(R).[T6].Value
    Next
End Sub

Hi Marc L. The code works great! Thank you for helping me - I really appreciate it You're the man!

 

[xtlchief]

Marc L.
This was just what I needed too. Thanks for sharing your knowledge!!!

 

[Marc L]

You 're welcome !​

​

And if you really enjoy it, click to bottom right of the post code on Like ! Thanks !​

​

 

[JJofSteel]

I know this tread was a long time ago...
But the macro still works.
Does anyone know how to adapt this so it creates a list of hyperlinks to the sheets as well?

 

[p45cal]

This article may help:

VBA Express : Excel - Create a Table of Contents

Create a Table of Contents This code creates/updates a Table of Contents for a specific workbook.

www.vbaexpress.com

 

[JJofSteel]

This article may help:

VBA Express : Excel - Create a Table of Contents

Create a Table of Contents This code creates/updates a Table of Contents for a specific workbook.

www.vbaexpress.com

That looks really good thank you