Hi guys,
Can anyone help me please I normally use the Macro recorder to aid my VBA but in this particular case I want to do a search as in VLOOKUP but at the end of the sequence insert a value. I want to Search in Sheet Payments Column A for a match to the contents of Worksheet Jobs M1, and then copy the contents of Sheet New Invoice E39 to column C of the same row in Sheet Payments. If anyone could point me in the right direction I’d be extremely grateful.
grf.
Can anyone help me please I normally use the Macro recorder to aid my VBA but in this particular case I want to do a search as in VLOOKUP but at the end of the sequence insert a value. I want to Search in Sheet Payments Column A for a match to the contents of Worksheet Jobs M1, and then copy the contents of Sheet New Invoice E39 to column C of the same row in Sheet Payments. If anyone could point me in the right direction I’d be extremely grateful.
grf.