gleemonex69
New Member
- Joined
- Dec 9, 2010
- Messages
- 37
I apologize if this has been covered in a previous post, but here goes. I am working on an Excel project that will greatly help me in doing my bar inventory. If I play my cards right, I might get a promotion! I would like Excel to auto-populate data from another worksheet when I fill in a cell in another worksheet. For example, I am typing in Wild Turkey 101 in the description column, and I would love for Excel to auto-populate the Tare weight and the size of the bottles in two adjacent cells. The data is available in a separate worksheet, which I am currently going back and forth to fill in. Please see the links to see what I mean. Thank you in advance.
The Liquor Tab
https://skydrive.live.com/redir?res...uthkey=!AKSHQyA-CFp0TWo&v=3&ithint=photo,.PNG
The Tare Tab
https://skydrive.live.com/redir?res...uthkey=!AOXmp7ocLWfmZNg&v=3&ithint=photo,.PNG
The Liquor Tab
https://skydrive.live.com/redir?res...uthkey=!AKSHQyA-CFp0TWo&v=3&ithint=photo,.PNG
The Tare Tab
https://skydrive.live.com/redir?res...uthkey=!AOXmp7ocLWfmZNg&v=3&ithint=photo,.PNG