Data Validation - Tabs

  • Thread starter Thread starter AMH
  • Start date Start date
A

AMH

Hi, I am trying to create a data list for using as a drop down selectable
list from a cell that contains the name of a series of tab's within a
workbook. I want to be able to selct the tab and then extract data from it.

I think I can produce the formula to extract the data from each tab, I just
need a way of producing a list of tab's into a series of cells or 1 single
cell

Any idea's ?
 
I just need a way of producing a list of tab's into a series of cells ..

One way is to install/run this sub on a new sheet
The list of tabs will appear in A2 down

Sub ListSheetNames()
Dim wkSht As Worksheet
Range("A2").Select
For Each wkSht In Worksheets
Selection = wkSht.Name
ActiveCell.Offset(rowOffset:=1, columnOffset:=0).Activate
Next wkSht
End Sub


---
 
Back
Top