| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidating Various Excel Files
Hi,
I have few excel files that needs to be consolidated every month. All the columns in these excel files are same just that the data in each of the files would vary in terms of number of rows. I want to consolidate all these excel files into one master file, where data would appear in one row after the another row. Names of the files would change every motnth. Can you help me with this request. Cheers, Mandeep |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Consolidating Various Excel Files
Hi
Ron de Bruin has produced a lot of code for carrying out these tasks. Take a look at http://www.rondebruin.nl/copy3.htm -- Regards Roger Govier "Mandeep Dhami" wrote in message ... Hi, I have few excel files that needs to be consolidated every month. All the columns in these excel files are same just that the data in each of the files would vary in terms of number of rows. I want to consolidate all these excel files into one master file, where data would appear in one row after the another row. Names of the files would change every motnth. Can you help me with this request. Cheers, Mandeep |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Consolidating Various Excel Files
Thanks Roger you macro helped me.
"Roger Govier" wrote: Hi Ron de Bruin has produced a lot of code for carrying out these tasks. Take a look at http://www.rondebruin.nl/copy3.htm -- Regards Roger Govier "Mandeep Dhami" wrote in message ... Hi, I have few excel files that needs to be consolidated every month. All the columns in these excel files are same just that the data in each of the files would vary in terms of number of rows. I want to consolidate all these excel files into one master file, where data would appear in one row after the another row. Names of the files would change every motnth. Can you help me with this request. Cheers, Mandeep |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Consolidating Several Excel Files | Excel Programming | |||
| Need advice : consolidating data from multiple CSV files in Excel - External data handling | Excel Programming | |||
| Consolidating tab-delimited text files | Excel Programming | |||
| Consolidating multiple files into 1 target | Excel Programming | |||
| Consolidating multiple files using a row column range | Excel Programming | |||
Hybrid Mode
