I have an excel workbook that has 2 worksheets. I would like to have a dropdown menu in worksheet A that has 2 different cells, one that selects a product from Worksheet B and then have the second cell in worksheet A auto populate with the price of the product selected. Can someone assist me in getting started on how to do this?
Thank you in advance!
Paul
Thank you in advance!
Paul