Match cells in different columns and move them

[Evans]

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,

 

[WinteE]

Why don't you use a VLOOKUP formula ?