retrieving data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have multiple worsheets that contain a form that is protected except for
the cells we want filled out. I have a master sheet in which I want to pull
certain information from each of the individual forms. For example, each
form has the specific company's name and this is one thing i want to be
automatically pulled from each individual form into the master sheet. Is
there a formula that will pull each individual company name into the master
sheet?
 
I assume that you replicate the worksheets for each new company. Each
worksheet has a name. One solution:

You can compile all sheet names in a separate sheet (next to the
master list you want to compile). Say these are in cells A2:A100. Say
the cell with the company name in each sheet is F3. Next to A2:

=INDIRECT("'"&A2&"'!F3")

Copy down. To compile a list of the sheet names in A2:Ax of sheet
"Master"

Sub CompileSheetNameList()
dim sh as Worksheet
j = 2
For Each sh in ThisWorkbook.Worksheets
Sheets("Master").Cells(j,1).Value = sh.Name
j = j + 1
Next sh
End Sub

HTH
Kostis Vezerides
 
Back
Top