Hi guys,
Hoping to get some help with a reverse calculating VAT invoice I am working on.
I have all my calculations correct, and my invoice does exactly what I want it to.... however....
I have a list of about 100 products, all with different prices. This list can be on the same worksheet, or another, hidden away somewhere, and consists of two columns; a description, and a corresponding price. The list is maybe 100 rows.
I would like to be able to pick from a drop down list in Cell C2, and have C2 to display the product, and Cell D2 to display the price.
I have attached what I have so far, and would really appreciate some help. I know there is software out there for invoicing, but I'd rather try and get this fixed if poss.
Really appreciate any help, and I hope you chaps can understand what I'm on about!
Thanks, Andy
Bookmarks