I have a po form that I set up. I have to autonumber a cell each time it is opened. I need to be able to "save as" each po but continuing to autonumber. I know there is a way to write to another worksheet the date/time and po number each time the form is accessed. I just can't figure out how to do this. This is the Macro that I am using:
[vba]Private Sub Workbook_Open()
MsgBox "You are now entering a new PO That's right..."
Worksheets("Sheet1").Range("B1").Value = Date
Worksheets("Sheet1").Range("D1").Value = _
Worksheets("Sheet1").Range("D1").Value + 1
End Sub
[/vba] any help would be greatly appreciated. Thanks so much
[uvba].[/uvba] ~Oorang