Create Invoice numbers with Customer Initials in Excel
Add letters to invoice numbers
For more help visit my website or email me at easyexcelanswers@gmail.com.
I can customize this Excel application for your exact needs for a fixed price of $50. The work is normally returned within 24hrs.
I am able to provide online help on your computer at a reasonable rate.
MY videos are all created on Camtasia.
Follow me on Facebook
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Thanks it was very helpful
i just found this single video of yours, and I'm so grateful. I'm subscribed and will be watching anything you have! Thank you.
0:37 – start
hello!, i wanted to start as well my INVOICE NUMBER in diff. company like this, BC1001-
-BC100.., SC1001-SC10……,JC1001JC10……… do have some formula for that??> thank you.Cheers Barb! That's Brilliant! Much appreciated and more power to you!
Hi Barb, is there a way or a formula where a self generating Reference Number is created each time I open this Document? I'm in logistics and we're sending out multiple shipments everyday and I'm always manually creating this reference no. with the use of a little Goods out book. Would appreciate your help on this.
Thank you for the this…but I am using the same formula to generate Project Numbers. I keep getting a #VALUE! error when I drag the formula down the column. What am I doing wrong? The first (top) runs the formula correctly but when I drag/copy the formula down I get the error…beyond frustrated!
LOT OF THANK BUT can i generate as G0001/17-18, G0002/17-18, G0003/17-18 UP TO G9999/17-18 IF YES PLEASE GIVE THE FUNCTION KEY HOW I DO THIS
кинул straik за спам
the only way to fix this is with VBA
it would look something like this
Sub fordate ()
Dim I as Integer
For i =2 to 100
If cells (I, “A”).Value <> “”
Cells (I, “E”).value =Date
Cells(I,”E”).numberformat=”m/dd/YYYY"
End if
Next
End sub
Is there a different formula to achieve my goal? Or am I stuck manually entering dates?
I have another question. I have a running ledger of items I have shipped to customers. I have a column with a dropdown box with blank / paid /missing tax . The next column over is for the date. I am trying to get the date to autofill when I click paid or missing tax from the dropdown box. The formula I am currently using is =IF(N10="Paid",TODAY(),IF(N10="MISSING TAX",TODAY(),)) . The problem is when I open the spreadsheet a day later the date will update to the current day. I want the date to stay the same as when I initially clicked paid or missing tax.