dancall992
New Member
- Joined
- Aug 8, 2018
- Messages
- 1
Hi All,
I struggling to consolidate a number of sheets in to one Master sheet.
I've a raw data sheet where a row indicates a project, each project has a spend amount in various quarters of the financial year
I've then separate sheets that are then populated when a column has a value greater than 0 that relating to a "financial quarter" so if a project has spend across two quarters then it would appear as a line in two separate sheets, i.e. a Q1 Sheet and a Q2 Sheet.
This is all working but I then want to consolidate these sheets so that all of the lines in each separate sheet are cut and paste in to a master sheet that is then sorted in quarter and financial year and saved as a CSV file
I'm not sure how do the above without recording a macro, but as there are 20 quarters worth of data and the "master sheet" needs to be updated every two weeks I wondered if there was simpler way??? PLEASE HELP!!!
Thanks
Dan
I struggling to consolidate a number of sheets in to one Master sheet.
I've a raw data sheet where a row indicates a project, each project has a spend amount in various quarters of the financial year
I've then separate sheets that are then populated when a column has a value greater than 0 that relating to a "financial quarter" so if a project has spend across two quarters then it would appear as a line in two separate sheets, i.e. a Q1 Sheet and a Q2 Sheet.
This is all working but I then want to consolidate these sheets so that all of the lines in each separate sheet are cut and paste in to a master sheet that is then sorted in quarter and financial year and saved as a CSV file
I'm not sure how do the above without recording a macro, but as there are 20 quarters worth of data and the "master sheet" needs to be updated every two weeks I wondered if there was simpler way??? PLEASE HELP!!!
Thanks
Dan
