Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combine Closed Sheets
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine sheets into one | Excel Worksheet Functions | |||
Combine to Sheets... | Excel Discussion (Misc queries) | |||
HELP!!! combine 4 different sheets ??? | Excel Discussion (Misc queries) | |||
Possible to copy sheets into another (closed!) workbook? | Excel Discussion (Misc queries) | |||
Accessing All Sheets in a closed workbook | Excel Programming |