ExcelBanter - Vlookup in VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Vlookup in VBA (https://www.excelbanter.com/excel-programming/420868-vlookup-vba.html)

Brian

Vlookup in VBA

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

All times are GMT +1. The time now is 06:15 PM.