Hi,

I currently have a Vlookup in VBA that is finding data in one sheet (PS) and
pasting it into another(Sheet1). However, I need to find the value with the
vlookup then copy/paste a value that in 15 columns to the right and "next
blank row -1" down. Is this possible?

Any help would be much appreciated.

Brian