Hi Team,
I am looking for a consolidating macro which will consolidate multiple sheets data into one.I have arange of sheets from As tp XC and consolidated sheet to collect information.There are 3 sections in the sheet
1overall capacity
2H&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
Bookmarks