H
huwzee
i want to set up automatic next number generating for a purchase order spread
sheet
sheet
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike
In principle it's simple but it would help if your provided more detail.
Specifically, where should Excel look for the last number. Is it in the open
or another workbook or a file.
Specifically, where should Excel look for the last number. Is it in the open
or another workbook or a file.
H
huwzee
Hi Mike
i need it to generate the next number in the sequence i.e. 001, 002, 003,
etc for each individual purchase order, it should look for the number from
the previous purchase order, i just want 1 specific cell on the spreadsheet
to do it.
thanks,
steve
i need it to generate the next number in the sequence i.e. 001, 002, 003,
etc for each individual purchase order, it should look for the number from
the previous purchase order, i just want 1 specific cell on the spreadsheet
to do it.
thanks,
steve
M
Mike
Ok, One approach.
paste this macro in the current PO workbook you are using
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)ponum = link to the cell where the PO number is stored
Workbooks.Add
Filename = "NextPOnumber" & ponum + 1
ActiveWorkbook.SaveAs Filename:=Filename
End Sub
Somewhere in the work I imagine you will have the PO number. Edit the line
ponum to point to the cell that contains this number.
The macro will run when you try to save your current bok and it will open a
new book and save it with the file name nextponumber# where # is one more
than the current book.
Was this helpful?
paste this macro in the current PO workbook you are using
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)ponum = link to the cell where the PO number is stored
Workbooks.Add
Filename = "NextPOnumber" & ponum + 1
ActiveWorkbook.SaveAs Filename:=Filename
End Sub
Somewhere in the work I imagine you will have the PO number. Edit the line
ponum to point to the cell that contains this number.
The macro will run when you try to save your current bok and it will open a
new book and save it with the file name nextponumber# where # is one more
than the current book.
Was this helpful?
H
huwzee
hi mike
ive set up the macro how do i link it to a specific cell
ive set up the macro how do i link it to a specific cell
M
Mike
ponum = link to the cell where the PO number is stored
ponum= worksheets("Sheet1").cells(1,1).value
adjust to suit
ponum= worksheets("Sheet1").cells(1,1).value
adjust to suit