Macro to create 3 Summary Sheets from a Data Sheet

Try

Please Login or Register  to view this content.

Thanks Jindon,
Please see the output of the code
Kindly refer to the OP Data sheet where I had mentioned that if the values of Col A and Col B are same than the value of Col B should show only once.

Please see my comment on the attached sample on FLRS and PTR sheets

Secondly is it possible to have the output sheet in the alphabetical order when Col C is filtered, and have all the summary sheets to have column D with Number formatting with 2 decimal places and Autofit to Column width

Thanks once again

Dear Jindon,
The problem of Col A and Col B is solved by the amended code

Would you please see into the following:

• Output sheet to come in the alphabetical order as per Col E filtered values, now the output sheete is taking the values filtered as per Col C.
• All sheets created by the macro to have column D with Number formatting with 2 decimal places eg: #,##0.00
• All sheets to be Autofit as per Column width

Thanks once again for all your time and help

Originally Posted by rehana402003

Would you please see into the following:

• Output sheet to come in the alphabetical order as per Col E filtered values, now the output sheete is taking the values filtered as per Col C.

I don't understand the above.

Originally Posted by rehana402003

• All sheets created by the macro to have column D with Number formatting with 2 decimal places eg: #,##0.00

The data is copied from the "Data" sheet, so just change the cell format in "Data" sheet as you want.

Originally Posted by rehana402003

• All sheets to be Autofit as per Column width

Just add one line in bold

Please Login or Register  to view this content.

Dear Jindon,

Please see the new sample to explain the filtering of Col E and Col C

Thanks for your time and help

Please Login or Register  to view this content.

Thanks a Ton Jindon
You are a star
Post marked SOLVED
Once again thanks for all your support and help