tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
I have two sheets
1 called "Database"
2 called "Inputs"
Now Database has all my product names and data in it
Product Lookup is in Range D10:D500
Product E
Price F
Size G
So Heres what i want to do
In Sheets Inputs Range G7:G37 In have drop down boxes
If i choose a dropdown box the macro is triggered,
The dropdown box has Product Lookup names
so the macro should, look at cell and see name of Product look up,
find that name in Sheet "Database" range ("D10:D500") and return the Product in column E to Inputs column J, Price to Column M and Size to column P
I know this can be done with formulas but i need it to be done with macros
data must on copy over Values
please help if you can
Thanks
Tony
I have two sheets
1 called "Database"
2 called "Inputs"
Now Database has all my product names and data in it
Product Lookup is in Range D10:D500
Product E
Price F
Size G
So Heres what i want to do
In Sheets Inputs Range G7:G37 In have drop down boxes
If i choose a dropdown box the macro is triggered,
The dropdown box has Product Lookup names
so the macro should, look at cell and see name of Product look up,
find that name in Sheet "Database" range ("D10:D500") and return the Product in column E to Inputs column J, Price to Column M and Size to column P
I know this can be done with formulas but i need it to be done with macros
data must on copy over Values
please help if you can
Thanks
Tony