Using Price list to populate Purchase order.

**Vaalshuffle** · 03-01-2013, 06:57 AM

Hi there Guys new to the forum and hardly ever work in excel. I have been sent a price list from a supplier and need to create an order form that can be populated from the price lists. I have to pages of price list as well. I will also be adding to these as I start getting other supplied product and need my client to be able to generate a order from these in the simplest way possible. Again I hardly use excel and these docs are all sent in excel format. Can someone show me the easiest way of doing this any help would be greatly appreciated.

Kind regards
Charl

**Vaalshuffle** · 03-01-2013, 07:01 AM

I forgot to add the file sorry!!!!

**Tank997** · 03-01-2013, 12:39 PM

Here's a start, give it a try and see if it does what you're looking for.

**newdoverman** · 03-01-2013, 06:42 PM

This might give you an idea of what you can do.

**sloninja** · 03-02-2013, 12:02 AM

i put in 1 drop down box, and 1 insert cell. red cell = insert quantity you want. it will populate itself. the catch is, you can only look at 1 item at a time.