Hi - I'm new to this forum and to Excel macros in general so apologies if my problem is not clear and forum etiquette poor.
Basically what I want to do is automatically search the range M3:X50 for the colour orange and copy the data contained in these orange cells into the column Y (from Y3 down) using a macros or other excel function.
I have attached a sample spreadsheet to illustrate what I want to do.
Thank you in advance.
David
Bookmarks