i am trying to make one cell automatically change to current date and time when the cell next to it has changed value. ive search other posts but cannot figure this out. so if cell A1 changes value cell B1 should automatically fill with current date and time cell A1 changed value. Thanks
See attached- a solution using VBA- I think this is what you wanted- when you change the value in cell A1 and hit enter the date and time in b1 l will change
If you require an explanation just ask
Regards
Strud
Last edited by strud; 02-14-2014 at 12:00 PM.
would actually work better if the module code is:
(the code on the worksheet is fine though)
Please Login or Register to view this content.
Regards
Strud
Last edited by strud; 02-14-2014 at 12:07 PM.
Hi hitech,
Here is another VBA solution. Use View code by right clicking the sheet you want this in and you can make the WatchRange for whatever column you like
Hope this helps.Please Login or Register to view this content.
----
Mark threads as Solved
Star those that help
I guess im really not understanding the scripts and where to place them. I have attached a copy of the sheet. im also looking to make it so if the column named status shows a value of not interested to make the whole row red. if it has any of the other options in the drop down to make the whole row green
I recently added this to a worksheet. F11 to open VBA. Select the worksheet you want this to run on. Change the column number to the column you want watched (here it is 5). It also allows a cut and paste of multiple rows.
Please Login or Register to view this content.
Hi Hitech,
I downloaded your spreadsheet and made the following changes.
- The VBA Script I posted earlier is in the Code for the Leads sheet. Now when you enter a salespersons name, it will autofill the current date in column B
-- I used conditional formatting so that if you select NOT INTERESTED in column H, it highlights the row RED
--- There is also a dropdown list in Column H for you to select the Status code based on the list you had in the Data tab. Use Data validation to create dropdown lists.
I recommend taking a look through the formatting so you can become more familiar with how this was done.
Hope this helps.
salesleadtracking.xlsm
thank you very much it works. I was trying to find where you set it to be red if NOT INTERESTED is selected to see if I can do something with other colors for other values in that cell. where did you set the formatting for that?
thanks again
You are welcome hitech.
The formatting is on the Home Ribbon .. about the middle of the ribbon is Conditional Formatting .. Select Manage Rules from the dropdown to see the way that is setup.
Let me know if you have any other questions.
---------------------------------
Don't forget to mark the thread as Solved.
Click on the star for everyone that helped with your question to show you appreciate their time.
Thank you I see it now and it works. I appreciate your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks