column a | column b | column c | column d | column e | column f |
10 | company A | 40 | D | ||
20 | company B | 20 | B | ||
30 | company C | 10 | A | ||
40 | company D | 50 | E | ||
50 | company E | 30 | C |
<tbody>
</tbody>
Hello,
Thanks for reading, and appreciate suggestions.
I need a macro that goes down column A finds a matching cell value in column e.
So, it finds a matching cell value in 3rd row for first cell.
It then moves the matching cells (in red) exactly into the cells with "" .... along the same row.
thanks again,