Summary Sheet

  • Thread starter Thread starter Ket
  • Start date Start date
K

Ket

I am using excel 2K and Windows 2K.
I have a workbook that contains a number of identically formatted
worksheets.
Each workbook has a different name and contains different information.
Can a summary sheet be created that lists all the worksheet titles in
one column and next to them has the information from 3 specified cells
in that worksheet?
The cell references would be that sam ein each sheet.

Thanks in advance.

Ket
 
Can a summary sheet be created that lists all the worksheet titles in
one column and next to them has the information from 3 specified cells
in that worksheet?
Click to expand...

It's a cinch to create using VB. Just a simple loop, created using
for each wb in Workbooks

and referencing wb.name.
 
Back
Top