How to Enter Date and Serial Number Automatically When data is entered in excel

In this advanced excel tutorial you are about to learn how you can auto populate date & serial no at a time whenever you enter a data. Now in our day to day job we use excel and every time we have to manually enter date and serial no to our workbook whenever we enter any data. Its a common procedure.
But if you have to input several entry a day adding date and serial number separately makes the job tedious. This is why in this excel tutorial we are going to write a VBA (Visual Basic for Application) code so that we can automatically enter serial no. and date whenever we enter any data. We are using Microsoft Excel 2019 for the demonstration. Lets get started.

Step 1: Right click on the "Sheet tab"
Step 3: Vbe (Visual Basic Editor) will open.
Step 5: Save the file with .XLSM format.
Done.
Now whenever you enter data in column C date & time will auto populate in column B and serial no. will auto populate in column A.

Thanks for watching.
#Autofill #Date&SerialNo
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Playlists:

Social media:

[moesadr]

What about if we have a worksheet with multiple columns ( let's say 10 coulmns) and would like to automativcally register the date if any cells in a row has been changed/ updated? So basically having a column for LAST UPDATE date stamp??

[wayneseymour]

I have a data sheet that I input data from a user form. One aspect of
the form is that as you finish adding the data and before you submit it
to the data sheet a ID number is generated using the MAX function +1 in
the VBA code which just increments 1, 2, 3, 4. The user form is used to
enter, add a Vendor (contractor, Owner or Company name), this is done via
a combo box with the names and equipment type. some names are two or
three words, ie. "Bob Cat Services" or "Azan Heavy Equipment", "Ron
Wilson"), but always a combo of more than one name. There is another
combo box that holds the type of equipment owned or listed by the
vendors, contractors("Backhoe", "Roller", "Dozer", "Dump Truck"etc.) I would
like to have a Label or text box that will, as the names, ie, vendor and
equipment are entered it will create a unique ID Number... like for
example "Bob Cat Services, uses BCS for the vendor, equipment like
"Back-hoe" or Bh for the equipment followed by a number most likely
starting out with 0001. Making the serial number; BCSBH0001. THIS WOULD
CHANG DEPENDING ON THE NAME AND EQUIPMENT. but always using the first
three letters or two of the vendor name like if its more than one word
"B" from Bob, "C" from "Cat" and "S" from "services", then add the first
two letters from the equipment BH for back-hoe or just the first two
letters if its spelt "Backhoe". Then lastly adding 0001, to end up with a
unique serial number BCSBH0001 which tells the company, vendor and the
equipment type. This makes for each vendor the serial is different "Azan
Equipment" would be AEBH0001, "Bob Cat Services" would be BCSBH0001 and
so on. After that any addition entry would read the column of the ID in
the data sheet and add the next sequential number belonging to that
serial group, ie AEBH0001 would become AExx0002, (xx being the first two
letters of the equipment type) or BCSxx0002 and so on. Granted
something like "Dump Truck" may pose a problem. But thats the jist of
what I'm trying to achieve. Hope someone can help. I'm new to VB so I
find it hard to figure out the code. Please help. THANKS to everyone.

[lokeshd]

Sir, I want to generate serial number using one criteria in a data sheet. pls tell the code

[sanaokarian]

our Cash desk recive fee vouchers.when deposit a diary or paid number is generated mannualy.when we entered vouchers in excell sheets. i want that a paid voucher and date only specific column in same row...like this we collected today vochers number 1 to 90 today next day we collect 91 to 140..plz guide and send code regarding this querry...thanks very much.

[wafaaeid]

Thanks for the video. I added the code, it does work with date and time but does not work with the serial No.. Any advice

[sanaokarian]

i hv a school... i wana enter deposit amount against any children deposit fee randomely row..i want generate a serial number and date regarding deposit voucher. deposit voucher specifice row on same student record
collected from cash counter in a serial like 1 to 999..one day it could be 1 to 70 second day it will be start from 71 to 120 so over like this...

[rashedulislam]

Sir, When i entry data it creates serial number. But when i remove data serial number not removed automatically. What should i do. Please give me a solution.

[PaulLincoln]

What if there is multiple sheet and data entered by combo box in userform

[everyone]

Bro please make a video on how to do this in google sheets

[sebbe]

Can i pl;ease get the code? Thank you!

[mariacelebrateslife]

Im interested what is the email? I want to put one and time in every entry i make … do you have yt vid for that?

[azankmarddin]

sir please sent the code.i azan from malaysia.tq

[HabibKhan-vdip]

Sir I have same formula use after my Excel not not respond pls what to do

[edwinaron]

Send the code to me sir, i subscribed.

[moethuzar]

I like your video and signed up. Please, send code to me, Sir.