Combining several Excel files into 1
Each month I have a number of Excel files populated (each having 1 worksheet
which is labeled, columns/ rows are formatted, so they have blanks in them). I need to be able to combine them, so that each file becomes a worksheet within a master file. Any way to do it without moving/ creating a copy each and every time? Thank you. |
Combining several Excel files into 1
Hi Margo
Start here http://www.rondebruin.nl/fso.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Margo" wrote in message ... Each month I have a number of Excel files populated (each having 1 worksheet which is labeled, columns/ rows are formatted, so they have blanks in them). I need to be able to combine them, so that each file becomes a worksheet within a master file. Any way to do it without moving/ creating a copy each and every time? Thank you. |
All times are GMT +1. The time now is 12:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com