Hi All!
What I'm doing/using the workbook for:
- I have created a workbook, using conditional formatting, that highlights an entire row if a specified column contains a certain word. It does this for a list of 12 specified words.
- I copy a data set (with a specific data format) and paste it into my workbook
- It highlights the rows of interest for me for ease of view/to save time from looking to see if the row qualifies to be put into the final workbook sheet of qualified data sets
My Question:
How do I then have Excel take only the highlighted rows and automatically copy paste them into sheet in the workbook?
Bookmarks