Each month for our income statement monthly report I run 4 reports from our report writing program and save the results as 4 separate Excel files. The problem is, the company officers do not want 4 separate Excel files, since this information is published each month in our monthly business report.
Therefore, they have requested 1 Excel file. Each of the 4 Excel source files will become a worksheet in the destination file. Each worksheet in the destination file is preformatted in a specific layout (row/column headings). I have just created a template file that will become the destination Excel file. This template needs to be used each month.
Basically, I need the destination file (workbook) to be the template/master and the 4 Excel files as the source. I would like the VBA code to copy and paste the cell value (not range), specific cells, since our report writing program saves the data very badly in Excel, much of the formatting is lost and nothing is lined up properly.
However, even though the formatting is lost, it still puts the results in the same cell each time. Therefore a cell reference will work. I need a macro that will copy the source cell from one source workbook (file) and paste value in the destination cell of the template file (workbook). Once I have this code I will repeat this process for all and save this as the template. I will need to set this up probably one cell at a time. So I just need help in getting started. Is this the best practice or is there a better solution?
Also, should I be use two macros? One macro to create the template and the other macro to perform the copy and paste cell values&? Im not sure how that will work? Anyway, can someone help? I could not find a solution that fit my needs. Thanks and let me know if you need more info?
Start Free Trial
