Hi
I'd like to populate a cell from the contents of a list box containing CompanyName once a selection is made. The list box is in Sheet1, the list is generated from CompanyName data in a column in Sheet2. In Sheet3 there is a column containing CompanyName data along with a DiscountRate and various other fields.
When the user selects from the list in Sheet1 I'd like a row next to CompanyName to display the DiscountRate from Sheet3 where the CompanyName in Sheet3 matches the selection made. I think it's some kind of vba after update code but not sure how to implement, any help appreciated, thanks
Bookmarks