Solved Running Product Price list in tandem with a printable invoic

March 21, 2014 at 23:48:21
Specs: Windows 7
I have set up a Product list for our company with product dcodes, for ease of use, I want to run a fillable invoice nest to the product list, how can I do this

See More: Running Product Price list in tandem with a printable invoic

Report •

#1
March 22, 2014 at 08:08:07
✔ Best Answer
You haven't provided a lot of detail so we can't be very specific, but one possible method is to use Data Validation Drop Down lists and VLOOKUPs.

You could have a Drop Down list for your products or "product dcodes" (whatever those are) and then use VLOOKUP functions to pull in the prices if that's what you need.

There are lots of templates to get you started. Once you download something you like, you can add formulas and drop downs to customize it. Start here:

http://office.microsoft.com/en-us/t...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
March 22, 2014 at 14:29:06
Thank You, I realized afterwards that I should have told you that I had done the invoice and the product list in excel 7. I did figure out how to do most of it, but your answer was very helpful and I do appreciate it. Thank you. sue Mysynuk

Report •
Related Solutions


Ask Question