Auto Populate Cell when Row is Inserted
Hello,
This seems simple, but I can't seem to wrap my brain around it ...
How do I auto-populate a cell with Today's Date whenever a new row is inserted???
I am not trying to copy a formula from the row above, I want the date to auto-populate in the cell. 99 times out of 100, the user will not need to change the date, but on those few instances when they are late entering data, i need that cell to be edited without any errors when a formula is over written.
Thank you guys for any and all help!
Hi
There is no Before Row Insert Event to trigger your macro. So how else could you trigger it?
Ahh the worksheet change event is triggered when you insert one or more rows. So maybe you could use that.
Process
Has the number of rows Increased?
Find the address of the selected range
Place Date in Column A.
Right Click on your sheet name at the bottom of excel and select view code
Paste this code into the module that opens and close it.
Please Login or Register to view this content.
Last edited by mehmetcik; 10-05-2017 at 03:41 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks