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.
Hi,
you can try it with this:
Please Login or Register to view this content.
Greetings,
Cheetahke
thank you for your reply but it didn't work. Something is missing
Originally Posted by Cheetahke
Hi,
I don't know where you've putted your code, here's the entire code:
Please Login or Register to view this content.
I put it in Sheet1 View Code section,
I have realised the problem I have changedtoPlease Login or Register to view this content.everywhere in the codePlease Login or Register to view this content.
Thank you so much Cheetahke for great code, I spent 2 days sorting this out in the end Column was wrong too.
Last edited by lapot; 10-22-2015 at 11:52 AM.
Hi,
yes, try to implement this code behind your "amend button":
Please Login or Register to view this content.
Last edited by Cheetahke; 10-22-2015 at 01:32 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks