Hi Guys
I am struggling on some VBA code to put a value in column based on the cell cell value...
I would like the code to loop through Column A from cell A5 until it finds a blank cell and then stop. If it comes across a value which is in the table in Column H it will to assign the value in Column I to Column C. Pretty similar to a vlookup....
I hope this makes sense.. I have attached a spreradsheet which may help...
Any help would be great
Thanks
Bookmarks