Heres what I need to do, hope this is clear enough:
I have 2 sheets, 1 and 2 (duh)
On sheet 1, I have a list of products set up (There will be about 300).
Column A has the name and columns B and C have my price and selling price respectively.
On sheet 2, I want to be able to type in a customer name in column A, then have a pull down list in B next to the name of all the products. I got that working so far. The problem is when I pick a product in the pull down box, I want my price and selling price from Sheet 1 to fill in on sheet 2 Column C and D respectively.
If this is confusing, I try to explain a little better or upload a sample. Thanks in advance for all the help!!
Bookmarks