I have 2 worksheet that has some rows highlighted. I need to take the highlighted rows from these 2 worksheet and combine them into one.
I looked at the conditional formatting to see if there's a way to do this but I can't to get it down. Is there a way to do this?
I need to pull all highlighted rows from sheet1 and sheet2 and combine into sheet3. Then I need to check column A to make sure that there's no duplicate. Any help is appreciated.