New member Koenie

Dear all, I'm trying to learn more about writing macro's from you all.
Regards,
Koenie

I'm trying to build a macro that searches fill up colored cells through the entire workbook (in different sheets).
Best would be that those selected cells would be copied to the first sheet (with the information from the cells before and/or after).
I made conditional formatting rules in all the different sheets (if sheet1 , A1 = identic than selected cells in selected sheets, cell filled up with color yellow).
Building the macro to select those cells and copy them to the first sheet, gives me a headache. It seems to be more difficult than I thought. Can someone help me with this issue?
Regards,
Koenie

Hello Koenie01,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.