Macro extract data based on color background

hi all,

i am looking macro code to extract data from sheet1 to sheet2 & sheet3, with criteria background color :
1) extract data from sheet1 to sheet2 for data contains/highlighted yellow color background
2) extract data from sheet1 to sheet3 for data contains/highlighted red color background

for detail information, please see attached workbook..

any assistance would be greatly appreciated..

regards

john m

Hi John M,
try it

Please Login or Register  to view this content.

hi Nilem & Joakim N, you are really great...

many thanks, i am helped...