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.