I have fill colored items in Col D from row 2 onwards on sheet1. Where the values in Col D is in yellow, I need the rows from Col A to D copied and pasted using values on sheet2 (row 2 onwards) to A2 on sheet7
I have tried to write code to do this, but get a syntax : Compile error
Please Login or Register to view this content.
I have attached some sample data
your assistance in resolving this is most appreciated
Bookmarks