How to Auto Populate Comments from another Cell, into a cell that has a Drop Down menu dynamically

I have workbook with two sheets that keeps inventory per person. Problem is that their are so many items, that i have inserted a picture into sheet2 per item as a comment background. So the master list on sheet2 has an item number,name,and price. And when you scroll over it a picture of that item populates.

In sheet1 i have a Item name,price,and who has the item. I add person to the table, and have a dropdown that refers to Name List of inventory on sheet2. What i want is that the comments on sheet2, also show up on sheet one. For example using a Computer item in sheet2, when i select computer item in sheet one from the dropdown it will show the comment from the master list for that item. 

My Dropdown is 

=lstItems

which refers to sheet2 to a range of items with picture comments. Be awesome if their was permanent solution thats dynamic as i change the list.


July 8th, 2015 10:37am

Hi,

Based on your requirement, >>So the master list on sheet2 has an item number,name,and price. And when you scroll over it a picture of that item populates.<<. It might be need some VBA coding. Thus, I recommend you post the question to Office development forum in MSDN:

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
July 9th, 2015 1:53am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics