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 same in each sheet.

Thanks in advance.

Ket
 
Each workbook has a different name and contains different information. ^^ i assume you mean worksheet
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 same in each sheet.
Click to expand...

Yes, but it would require using VB macros (or an equivalent) to write to
the sheet. You can't do it with worksheet functions alone.

It almost sounds as if a database program, such as Access, would be better
for you.
 
Back
Top