Macro to extract Rows Colored with Yellow Fill and create a new sheet as per current month

Hello All,

I am using Excel 2010 and have the following problem.

I have a macro which looks up Value in Col C and compare it with Col B and color the value with yellow background color (See Account Sheet sample attached)

I want a macro which should copy all the yellow colored Cells from Account sheet together with Col A C D F H I K showing only the current month Column shown in Row 1.
Eg if the macro is run in the month of Aug the macro should create a new sheet named Aug

In September the new sheet would be Sept and so on and so forth

See the result on sheet for Aug required

A new macro or a modified version of my macro would help

Thanks in advance
Rashid Khan

Try:

Please Login or Register  to view this content.

Happy to help. Don't forget to click 'Add Reputation' as well!