VLookup VBA between sheets on selected columns

[Jasmaine86]

Hi All,

Not sure if there is a solution to my request as I am strugglying to find a solution that isnt a looped result.

I have a project where we will soon start to recieve data with pricing, all in the same format.

The list size will vary each time so it will need to be "As Long" on both.

I have a workbood and want a simple solution that will allow a copy and paste of data on one tab, and from a selected cell or column, the option to run a VBA vlookup.

if not possible, i am open to other ideas to get a similar result.

 

[Jasmaine86]

Hi All,

Not sure if there is a solution to my request as I am strugglying to find a solution that isnt a looped result.

I have a project where we will soon start to recieve data with pricing, all in the same format.

The list size will vary each time so it will need to be "As Long" on both.

I have a workbood and want a simple solution that will allow a copy and paste of data on one tab, and from a selected cell or column, the option to run a VBA vlookup.

if not possible, i am open to other ideas to get a similar result.

Just to add, I have tried the below VBA with an error:

Sub Automate_VLOOKUP()

Dim Jas_Cell As Range

For Each Jas_Cell In Range("J3:J3286")

Jas_Cell.Value = _
Application.WorksheetFunction.VLookup(Jas_Cell.Offset(0, -9), _
Sheets("Copy").Range("A2:E800"), 5, 0)

Next Jas_Cell

End Sub