Automatcially combining reports.

mkingrey

New Member
Joined
Nov 2, 2005
Messages
49
Hello,

I have a particular task that I would like to accomplish and would like to know if anyone has any suggestions/advice. I have 10-15 very basic excel files (2-4 columns of data) that I have to combine into on large report on a weekly basis. Currently I cut and paste the reports into my main report but I would like to write a program that can combine many sub-reports into 1 main report and formats the information in its repspective manner. I thought about using COBOL to input the files, format them, and them output them to the proper places in the main report, but I'm sure there is something better.

i'm not looking for any reponses in great detail, but if someone has any better suggestions that might could point me in the right direction that would be a great help!

Thanks,

Matt
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

iamtheeggman

New Member
Joined
Sep 20, 2004
Messages
18
Help

Are the spreadsheets in the same workbook? If so add an additional spreadsheet with all the formatting the way you want the report on the first page (top left of sheet) add either set it up so the cells in the actual report do any calculations or do them off to the side and link them to the report. If the sheets are in separate workbooks can they be combined into one?
 

mkingrey

New Member
Joined
Nov 2, 2005
Messages
49
Yes they are in different workbooks. I would like to write a program that opens several specified workbooks, reads the columns into variables, then processes and outputs the variables into a concatenated and formated single file.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,812
Messages
5,574,455
Members
412,595
Latest member
slim313
Top