Vba with vlook-up table

[FGaxha]

Help needed please:
How to get values from a source data with look-up table:
Column A Product Id = bb,cc, dd, ee, ff,gg:
Column F sales per day.
My lookup table column A Product Id. bb, cc, dd, ee, ff, gg

 

[Mario_R]

Hello. Your description has not been enough. It is necessary that you show us a concrete example of how you have your information and what you want to obtain.

 

[FGaxha]

Workbook1:
Column A = Product ID
Column F = sales amunt.

Workbook2 vlook table: vlookup table:
Column A Product Id. (Same Id as workbook1)
I want to bring all values at workbook2 column B, from workbook 1 column F.
Thanks again

 

[Mario_R]

Excel columns have more than a million rows: at what point did you tell us which rows your information occupies?...

You talk about "workbook1" and "workbook2" but you haven't commented out the sheet names.

I mention it to you a second time: show us your data from both workbooks (the actual data is of no interest except the locations of that data).

 

[FGaxha]

Sheet1 workbook1
Sheet2 workbook2

Both workbooks path: c/desktop/fatos

 

[FGaxha]

Need vba code to bring all sales from workbook 2 to workbook one,.
Workbook1: "C:\Users\Silvana\Desktop\Workbook1.xlsx"
Workbook2 "C:\Users\Silvana\Desktop\Workbook2.xlsx"

 

[Mario_R]

With both workbooks open, try the following:

Sub Macro8()
Dim ws2 As Worksheet
Set ws2 = Workbooks("Workbook2.xlsx").Sheets(1)
ws2.Cells(1).CurrentRegion.Delete xlShiftUp
With Workbooks("Workbook1.xlsx").Sheets(1).Cells(1).CurrentRegion
  Union(.Columns(1), Columns(6)).Copy ws2.Cells(1)
End With
End Sub

 

[FGaxha]

Thank you Mario,

It did not work!

 

[Mario_R]

What is the message you get?...

 

[FGaxha]

400 error