Combine Closed Sheets
 

Hi all

I am hoping someone can lend a hand

I have 13 spreadsheets that are all identical in format and structur
and contain information in the same places ( IE: Cell A1 contains
number ( can be different ) on all the spreadsheets. )

The spreadsheets are all saved in the same place, but have uniqu
names. But the names all contain the month they were created.

The question I have is this. Is it possible to Colate all th
information from the spreadsheets onto 1 "MASTER" list.

EG: All filenames in a certain location containing "JUNE" will have th
information stored in Cell A1 pulled forward to a NEW LIST in a ne
workbook.

Thanks for any hel

--
Message posted from http://www.ExcelForum.com

Combine Closed Sheets
 

Hi DB100

Start here
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"DB100 " wrote in message ...
Hi all

I am hoping someone can lend a hand

I have 13 spreadsheets that are all identical in format and structure
and contain information in the same places ( IE: Cell A1 contains a
number ( can be different ) on all the spreadsheets. )

The spreadsheets are all saved in the same place, but have unique
names. But the names all contain the month they were created.

The question I have is this. Is it possible to Colate all the
information from the spreadsheets onto 1 "MASTER" list.

EG: All filenames in a certain location containing "JUNE" will have the
information stored in Cell A1 pulled forward to a NEW LIST in a new
workbook.

Thanks for any help


---
Message posted from http://www.ExcelForum.com/

Combine Closed Sheets
 

Absolutley Perfect

Thank

--
Message posted from http://www.ExcelForum.com