Calculate Consolidated Summary

venkatv21@gmail.com

New member
Joined
Aug 26, 2013
Messages
1
Reaction score
0
Points
0
Location
Bangalore
Hello XL Mac Guru's


hope you are all doing fine.


here's my requiremnts


Project A worksheet: contains values for a row stating Preparation, Design, Execution, Total
Project B worksheet: contains values for a row stating Preparation, Design, Execution, Total
Project C worksheet: contains values for a row stating Preparation, Design, Execution, Total


there are also other sheets which has other values as well..


Running a macro - hould pik the values correspondong to row's Preparation, Design, Execution & Total and display it in one single sheet. this should be done only when the workbook has any sheet starting with the name "Project..."




Many thanks for help

Best Regards
MIR
 
Back
Top