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

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??

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

Subcribe, pls send me the code

Awesome work....

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

Please send me the code . I have subscribed

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

pls. send me the code

Send the code to me sir,i subscribed.

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?

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

I need the code, Please send me the code sir, thankyou.. subscribe done :)

Subscribed. Please send me the code

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.

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.

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...

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

Send me code please

I have subscribed please send me the code

AWESOME VIDEO! I HAVE SUBSCRIBE! Please send me the code. Thank you.

AWESOME VIDEO! I HAVE SUBSCRIBE! Please send me the code. Thank you

please send me that code ..thanks

please send me the code

Done subscription pls email the code

Great! This is what I was looking for ..........

AWESOME VIDEO! I HAVE SUBSCRIBE! Please send me the code. Thank you.

I have already subscribe and thumb up.pls send me the code . Thanks .

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.

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

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

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

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