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/