Hi Guys

So here is my problem..
In Column A .. I have the hyperlinks of the images.. These are all on my local computer ( I have approx 7,000 rows of this )
I want to insert the image in the corresponding link in Column B
I can do it individually , ( Then have to resize image to say height 0.9" ) but this is crazy and time consuming..
How can I automate this ?

Row Col A ... Col B
1 G:\Derek\Documents\RENDERED\ET 52 29 ST6.jpg Actual image
2. G:\Derek\Documents\RENDERED\ET 52 4VIEW.jpg Actual image
3. G:\Derek\Documents\RENDERED\ET 52 29 ST 5.jpg Actual image