Help me-how to auto generate refrence number in excel

DEAR EXCEL FORUM MEMBERS I NEED HELP HOW TO AUTO GERERATE QUOTATION REFRENCE NUMBER OR P.O REFRENCE NUMBER IN EXCEL (IF IAM MAKING THE P.O FOLLOWING NUMBER 12810 AFTER NEXT DAY OR ONE WEEK IAM GOING TO MAKE OTHER P.O FOR OTHER SUPPLIER NAME BUT I DONT KNOW LAST TIME (Previous)WHAT REFRENCE NUMBER P.O MAKE I DONT KNOW (I WANT LIKE THIS IF I CLIK P.O FORMATE OR QUOTATION FORMATE AUTOMATICALLY GENERATE NUMBER 12811)............THANKS HAPPY NEW YEAR

SCREEN SHORT IS ATTACHED.......... QUOTATION FILE IS UPLOADED FOLLOWING LINK http://www.filedropper.com/quotation

If you were to enter the Date and Time and only show the date in the Date field, you could use the serial number of that date and time as the Purchase Order # which would be the date and time that you entered in Excel's serial number format.Date and Time Serial number.JPG

Hi,

Assuming you have Excel 2007 or later, (please update your user details so that we may know) then try the attached.

Clicking the blue button will clear the current invoice and add the next number.

This is a very basic invoice template and could no doubt be improved by holding details of customers, addresses and perhaps logging every invoice as it is created.

Hi,

It's using a small amount of VBA code rather than functions. SPecifically

Formula:

Please Login or Register  to view this content.

The first line clears the range called "InvDetails" - basically the variable cells on the invoice sheet
The second line increments the cell named "NextNo" on sheet 2 by 1
The third line is necessary since you're using merged cells and the first line clears the Address To cells hence it's necessary to reinstate the words "Address To:"

As a general principle try and avoid merging cells. They really are more trouble than they're worth and cause problems in many situations too numerous to mention here.