venkatv21@gmail.com
New member
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
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