software

Hi, I would like to print out blank purchase orders - with the numbers
automatically generating - is this possible with this macro and if so how do
I make that happen?

Thanks so much! Your post was very helpful.Denise Broussardquot;Geoff Lilleyquot; wrote:

gt; Here's what you do:
gt;
gt; 1) Go to your Window menu, and choose Unhide. You should see a file called quot;PERSONAL.XLSquot; that you can open.
gt; 2) In that file, put in the LAST purchase order number you used.
gt; 3) Then, go to Window, and choose quot;Hidequot; again.
gt; 4) Go back to the purchase order spreadsheet.
gt; 5) Go to Tools-gt;Macro-gt;Visual Basic Editor.
gt; 6) Click on the file name on the upper-left hand corner.
gt; 7) Go to the Insert menu, and choose quot;Module.quot;
gt;
gt; Paste this code:
gt;
gt; Sub AddPONum()
gt; Dim PONum As Long
gt; Windows(quot;PERSONAL.XLSquot;).Visible = True
gt; Range(quot;A1quot;).Activate
gt; Do Until ActiveCell.Formula = quot;quot;
gt; ActiveCell.Offset(1, 0).Activate
gt; Loop
gt; ActiveCell.Offset(-1, 0).Activate
gt; PONum = ActiveCell.Formula 1
gt; Windows(quot;PERSONAL.XLSquot;).Visible = False
gt; Range(quot;B1quot;).Activate
gt; ActiveCell.Formula = PONum
gt; End Sub
gt;
gt; The only line you may have to change is the one that says Range(quot;B1quot;).Activate. Change B1 (keep the quotes) to refer to the cell where you want the PO number going.
gt;
gt; To run, just go Tools-gt;Macro-gt;Macros, and click on the macro name.
gt;
gt; Cheers,
gt; Geoff Lilley
gt;
gt; MCDST, Microsoft Office Master Instructor (XP/2000),
gt; Microsoft Office Specialist Master (XP/2000)
gt;
gt; quot;fortune10quot; wrote:
gt;
gt; gt; I am using Office 97 Excel Purchase Order template but cannot find out how to have my P.O. numbers to auto sequence. I have been manually assigning them a number.
gt; gt; Any suggestions?