Hi All,
Just wondered if you could help me.
Im not 100% confident when it comes to Macro's and I need a macro whereby any data within a given spreadsheet has a light blue cell colour (id = 24) is moved to a new spreadsheet. I also need the blank rows deleted from the source spreadsheet, so I have 2 sheets, one with the highlighted data and 1 without.
Both sheets have the standard naming conventions "Sheet1" (Source Data) and "Sheet2" (Where highlighted data is to be copied to.
Bookmarks