I'm not sure this is possible or not and cannot find an answer on Google or in Excel help.
I have a series of excel spreadsheets where I've highlighted a specific row in yellow for a specific reason over the past 12 months. Now of course I need all of those rows to be consolidated into one excel spreadsheet and failed to have the foresight to create a null value to put into the file in advance to identify it.
Question: Is is possible to create a formula/query/macro to extract any row that is highlighted in yellow and place it into a separate excel file in an automated fashion as opposed to me going back 52 weeks - week by week - and manually pulling them out?
Any help would be appreciated.
I have a series of excel spreadsheets where I've highlighted a specific row in yellow for a specific reason over the past 12 months. Now of course I need all of those rows to be consolidated into one excel spreadsheet and failed to have the foresight to create a null value to put into the file in advance to identify it.
Question: Is is possible to create a formula/query/macro to extract any row that is highlighted in yellow and place it into a separate excel file in an automated fashion as opposed to me going back 52 weeks - week by week - and manually pulling them out?
Any help would be appreciated.