Vba with vlook-up table

F

FGaxha

Board Regular
Joined
Jan 10, 2023
Messages
230
Office Version
  1. 365
Platform
  1. Windows
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
 
Sort by date Sort by votes
1681076672995.png
 
Upvote 0
yes,
I add a module on workbook2 and run macro based on your code
 
Upvote 0
So your second workbook is not called: Workbook 2.xlsx
 
Upvote 0
I can't believe you don't realize the difference between: .xlsx and .xlsm.
 
Upvote 0
Mario_R,

I did save as Macro enable but still doesn't work
1681079833605.png
 
Upvote 0
Macros do not work in workbooks with the "xlsx" extension.

Change that detail in the macro...
 
Upvote 0
You must log in or register to reply here.

Similar threads

K0st4din
  • Solved
Macro hide inconsistent selected columns in selected worksheets
Replies
6
Views
397
Alex Blakenburg
A
I
  • Solved
Excel Filtering for a Summary Tab
2 3 4
Replies
35
Views
1K
ItalianPlatinum
I
G
  • Question Question
Filing table with data from another table which match criteria
Replies
7
Views
108
HighAndWilder
H
C
  • Question Question
Vlookup formula that includes searching for specific criteria text within a group of cells
Replies
9
Views
482
AhoyNC
A
J
  • Question Question
Dynamic Email Generation via VBA - Extracting & Sending Data Across Multiple Sheets
Replies
0
Views
137
Jess1234556
J

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top