Hi, I have a dropdown list populated by another worksheet using a dynamic named list (inventory).
I would like to have cells adjoining my dropdown box automatically populate when I make a selection from the list using the data in cells adjoining that item in the other workbook (in this case specs on that inventory item).
Can you help?
Can you please provide an example...
--
Regards
PD
----- Don't Forget -----
1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
2. Thank those who have helped you by Clicking the scales above each post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Check out vlookup in this forum, there are literally 100's of posts on the topic.
I have attached an example. The 'inventory' spreadsheet has data that I wish to access - specification for various solar panel choices.
The 'Data Output' spreadsheet has a dropdown box where I select a panel model. I would like the appropriate specs to then wizz across to fill in the adjoining cells on the Data Output table.
How does that sound? Can't be too hard...
this may work for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks