Without explaining why, I have to take the highlighted cells that could be highlighted in any one of the 5 columns from either of the 2 tables and put it into one list. I tried to select the highlighted cells by doing a find, options, format, choose format by cell and selecting the highlighted cells. This does select the cells I want but I can't copy those selected cells into my column because "this action won't work on multiple selection." and I can't adjust the fact that there are 2 tables as I can't change the format of the excel sheet for other reasons.
Is there a way around the copying problem or is there another way to identify the highlighted cells and put them into one column without manually going through and referencing by line each column.
I've attached a small example of what I'm dealing with. Thanks for any suggestions.
Bookmarks