gowflow, continuing on and as you suggested you could do:
When an email comes in from our Western Union representative he has a copy of the spreadsheet I originally sent him with values filled out in Col H. I need those values automatically inserted into my Col H of the WU-Staging-FBME sheet - which you have.
There needs to be checking that the value from his Col H is put into the correct row of my Col H by checking the MTCN# (Col D), the Remitter (Col E) and maybe the Sender City and County (Col F) before the value from his Col H is inserted into my Col H.
Let me know what else you need. Thank you once again for helping me out.