when cell DATA changed , auto amend the other cells' Date,Time and User name?

**lapot** · 10-22-2015, 05:38 AM

Dear all
I have an excel sheet which I enter data in Colum A then it inserts automatically a Date Stamp in to Colum C, a Time Stamp in to Colum D and an User name in to column E by the below code.

What I like to do is if I or someone else amends the Colum A's data, I also want all the other columns data to be amended. What do I need to add to the below code in order to achieve this?

thank you for your help in advance

Please Login or Register  to view this content.

**Cheetahke** · 10-22-2015, 10:26 AM

Hi,

you can try it with this:

Please Login or Register  to view this content.

**lapot** · 10-22-2015, 10:38 AM

thank you for your reply but it didn't work. Something is missing

Originally Posted by Cheetahke

Hi,

you can try it with this:

Please Login or Register  to view this content.

**Cheetahke** · 10-22-2015, 10:50 AM

Hi,

I don't know where you've putted your code, here's the entire code:

Please Login or Register  to view this content.

**lapot** · 10-22-2015, 11:14 AM

I put it in Sheet1 View Code section,

I have realised the problem I have changed

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

everywhere in the code

Thank you so much Cheetahke for great code, I spent 2 days sorting this out in the end Column was wrong too.

**Cheetahke** · 10-22-2015, 01:30 PM

Hi,

yes, try to implement this code behind your "amend button":

Please Login or Register  to view this content.

when cell DATA changed , auto amend the other cells' Date,Time and User name?

LinkBack

Thread Tools

Rate This Thread

Display

when cell DATA changed , auto amend the other cells' Date,Time and User name?

Re: when cell DATA changed , auto amend the other cells' Date,Time and User name?

Re: when cell DATA changed , auto amend the other cells' Date,Time and User name?

Re: when cell DATA changed , auto amend the other cells' Date,Time and User name?

Re: when cell DATA changed , auto amend the other cells' Date,Time and User name?

Re: when cell DATA changed , auto amend the other cells' Date,Time and User name?

Thread Information

Users Browsing this Thread

Similar Threads

auto-lock cells after time is entered so that it cannot be changed

Inserting Time (or Date & Time) in a cell on each row when a cell in that row is changed.

Display the date and time each time the data in a cell range is changed

Time and Date when Data changed in next cell.

Have Date Auto Filled when Cell Data is Changed

how to run a sub after a value of a named cell (or cells) is changed by user

Auto insert date, time & user in columns when data is entered in another column?

Bookmarks

Bookmarks

Posting Permissions