Automatcially combining reports.

[mkingrey]

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

 

[iamtheeggman]

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]

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.