I am trying to create an invoicing system in excel. I have a spread sheet with a list off inventory in one column and the selling price in a column next to it. I want to create a dropdown box on my invoice to be able to pick the relevant product and also the price in the cell next to it. I can create a drop down box for the product list - no problem - but I cannot find a way of also bring in the selling price.
I scrapped the sheet as I wasn't making progress with the view to starting again.
I have it but am not familiar with it.
excel as I have a better understanding of it.
Thank you. I am obviously missing something. The dropdown box doesn't seem to work.
I'll take another look at it and try an understand why it's not working. I'll get back to you later.
Hi. No. There is the word apple in the dropdown box but it can't be changed to any of the other items in the inventory. Also I need to have multiple product on the invoice. I think I can manage that but the first issue is still not resolved. Your help is appreciated.
902 833 766
That seems to be Ok now. Only thing I need now is how do I increase the nuber of lines for the invoice. Thanks so much for your help