Is there an easy way to build a invoice using a product-list as a source (including the price of the product in a separate cell) using a pulldown menu in the invoice sheet. For example:
1) I have a 2 colomn excel sheet ('product-list'), with in column 1 a product name an column 2 a price.
2) I would like to make another worksheet (invoicesheet) containing multiple (25) pulldown menus where i can choose a product from the 'product-list' coulmn 1 (this is possible with validation/list). But I would also like to get the price of the product (from 'product-list' column 2) in the pulldown list (some sort of multuple column pulldown list), or otherwise get the price in the cell next to the pulldown menu.
Is this possible in any other way?
1) I have a 2 colomn excel sheet ('product-list'), with in column 1 a product name an column 2 a price.
2) I would like to make another worksheet (invoicesheet) containing multiple (25) pulldown menus where i can choose a product from the 'product-list' coulmn 1 (this is possible with validation/list). But I would also like to get the price of the product (from 'product-list' column 2) in the pulldown list (some sort of multuple column pulldown list), or otherwise get the price in the cell next to the pulldown menu.
Is this possible in any other way?
