karthikgoel
New Member
I get source file every week for multiple Streams (Project Areas) which need to be consolidated into a Report. Have included the structure of the source file and Consolidated report in the attachements. What I have been doing is copying data from Source file into Consolidated Report for that specific stream..literally cell by cell. Which is very painful and error prone.
Can someone help me with a macro that can directly open the source file and select the range of columns and rows that I want to be copied and paste them in the separate Consolidate Report excel in the required format.
E.g From Sample_Stream_1 file I only want range "E3:J8" against the relevant months for actual and forecasts in the consolidated Report file and from Sample_Stream_2 file I only want the range from the range "E3:I8"
Note: Each source file for a specific stream I get has different set of columns. which means
Stream 1 - Sample File 1
Stream 2 - Sample File 2 (with different columns from )
Consolidated Report shows:
Stream 1:
Stream 2..
so on
Can someone help me with a macro that can directly open the source file and select the range of columns and rows that I want to be copied and paste them in the separate Consolidate Report excel in the required format.
E.g From Sample_Stream_1 file I only want range "E3:J8" against the relevant months for actual and forecasts in the consolidated Report file and from Sample_Stream_2 file I only want the range from the range "E3:I8"
Note: Each source file for a specific stream I get has different set of columns. which means
Stream 1 - Sample File 1
Stream 2 - Sample File 2 (with different columns from )
Consolidated Report shows:
Stream 1:
Stream 2..
so on