Creating a Purchase Order

**jamie_2_fingers** · 10-19-2007, 06:45 AM

Hi All,

Not sure which functions to use in this scenario.

Need to create purchase orders using Excel.

I have 6 fields on one row that need filling in. In one of the fields I will enter the code, I then need the rest of the fields filled in from the data in another spreadsheet.

If anyone can point me in the direction of a function that will do this I can probably figure out the rest.

Thanks,

Jamie

**EdMac** · 10-19-2007, 06:58 AM

Hi,

Sounds like you need VLOOKUP

Ed

**jamie_2_fingers** · 10-19-2007, 07:10 AM

OK, not had must experience with that formula function, any chance of a quick example:

I enter my product code in B17 and need c, d, e, f, and g17 filled in from data that is located....

Code will be located in column b on sheet2 and the data needing to be pulled across will be in c,d,e,f and g of the same row.

Ta

**EdMac** · 10-19-2007, 07:23 AM

Hi jamie,

can you post an example of your wprkbook and the requirements - it looks like there won't be a problem, but need to see the data layout to create a solution.

Excel files need to be attached as ZIPPED files - select the file right click > send to > compressed file.

then use the manage attachements on the post form.

Ed

**jamie_2_fingers** · 10-19-2007, 07:31 AM

Files should be attached, quantity and total columns do not need to be filled in automatically as we will add these manually.

Ta

**EdMac** · 10-19-2007, 08:41 AM

Hi Jamie,

Try the attached - it will also calculate the total on each line. I've included some error trappingmto make sure that it looks OK when values are wrong or missed out.

Suggest all cells except the quantity and ref should be protected to prevent accidental messing up

Let me know how you go

regards

Ed