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]

Are both workbooks open?...

 

[FGaxha]

 

[FGaxha]

yes,
I add a module on workbook2 and run macro based on your code

 

[Mario_R]

So your second workbook is not called: Workbook 2.xlsx

 

[FGaxha]

Yes,
It is Workbook2.

 

[Mario_R]

I can't believe you don't realize the difference between: .xlsx and .xlsm.

 

[FGaxha]

Mario_R,

I did save as Macro enable but still doesn't work

 

[FGaxha]

 

[Mario_R]

Macros do not work in workbooks with the "xlsx" extension.

Change that detail in the macro...

 

[FGaxha]

Sorry but still error.