Hi Friends,
Hi Team,
I am looking for a consolidating macro which will consolidate multiple sheets data into one.I have arrange of sheets from As to XC and consolidated sheet to collect information.There are 3 sections in the sheet
1overall capacity
2 H&M capacity
3 fixed capacity-This formulized.
When the data will be filled for all the projects for the first two phases then in consolidated sheet I require the
overall capcity and H&M to capture resourcewise summary of total hours across all projects.
Fixed will be automatically calculated.Pls suggest how to do that.
Regards,
Aps
Hi Team,
I am looking for a consolidating macro which will consolidate multiple sheets data into one.I have arrange of sheets from As to XC and consolidated sheet to collect information.There are 3 sections in the sheet
1overall capacity
2 H&M capacity
3 fixed capacity-This formulized.
When the data will be filled for all the projects for the first two phases then in consolidated sheet I require the
overall capcity and H&M to capture resourcewise summary of total hours across all projects.
Fixed will be automatically calculated.Pls suggest how to do that.
Regards,
Aps