macro to produce purchase order data

hi guys

i have a purchase order sheet

firstly i have attached said spreadsheet
1st sheet is named purchase order
2nd sheet is named purchase order numbers

upon opening the spreadsheet i would like on sheet purchase order to automatically input the next available number from column a in sheet purchase orders ( in this case next available is st010 and put that into cell k12 on sheet purchase order

i then want to enter the relevant data in sheet purchase order cells
b16 , b23 , g23 , i23 and d28

i then want to click a button with macro attached to transfer that data in to sheet purchase order numbers

how do i go about this please

thank you

hi vba
glad you replied you help me so much

what sheet do i put that in?

dont suppose anyone can help with the first stage of the question please?

upon opening worksheet i would like it to recognise the next available purchase order number

nothing happens at all vba

the next number which would be st010 should go in to cell k12 of sheet purchase order
upon opening of workbook
but i get compile error invalid outside procedure
and it highlights the word set

vba

as you know im not very good with code so dont really understand what you mean by variables

over my head , not to worry , thanks anyway

vba
is it possible you could attach what yours is like and then i can go from there because i have tried everything that i can but to no avail

regards

thanks vba i get it now
but i dont see what th difference was with yours and mine

the last query of the thing is -

when i open the sheet it now pulls up the next number available (which is perfect )

i now want to create a button ( which is something i can do ) to input the date thats put on the purchase order ( you have the cells in yellow )(which is correct )
into the purchase order number columns as they are obviously

ie sheet purchase order cell b16 (supplier) into the same row as the purchase order number thats already been generated into sheet purchase order numbers into column b right next to the purchase order number lets say b16.
then date from purchase order into c16
and so on
then i will create the save part which i can do , clear cells on sheet purchase order and close.

then hopefully next time the sheet will then go down one more line to the next available purchase order number

thanks so so much

I hope I don't confuse things by adding this, but I was working on a Purchase Order setup for a friend of mine (see attached). Admittedly, the format was mostly taken from a Microsoft Template, but I did all the userforms and code. Feel free to check it out and change anything as necessary. A couple of notes:

1. I didn't create an event to launch the main entry userform (userform2). Feel free to implement a command button or something to do so.
2. I have included a summary page which has a listing of all the POs. There is a column where you can select whether or not it has been paid. On the summary sheet, if you double click on an invoice, it will automatically take you to the PO.
3. There is a hidden Vendors sheet in case you track vendors.

Let me know if this helps you at all.

hi bas
thanks for the help

i have to keep our purchase orders basically set up as they are ( company very fussy on things like that )

all i need to do is copy the relevant cells to the purchase number sheet

then save it

then next time i open it , it will give me the next number availablee

but yours is very , very neat

cant see any macros in yours

i just cant seem to get to grips with getting the info i enter to tally up with the relevant line on the purchase order number sheet