Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Inserting Timestamp when multiple conditions are true

0

I'm preparing a sheet where there are multiple columns. For each row, the cell in column L should have a timestamp when multiple conditions for data in other columns of the same row are true.
I've tried this with Formula, but no result. 
I'm totally unaware of VBA, can anyone help me with the code.
Refer attached file for the conditions & the manner in which data is appearing in different cells. 
Also for one particular condition I've written in both table & sheet format, will be great if I can get help with both formats.

Answer
Discuss

Answers

0

You will have to use VBA and Macros for this, there is sadly no way around it. That said, I made a great little video that shows you how to do all of it and includes the code that you need as well.

Automatically Timestamp Data Entries in Excel

Try that out and if you get stuck, you can ask more specific questions here about how to implement it or change it for your needs :)

Discuss

Discussion

Hi  

I have used the "automatically Timestamp Data Entries in Excel" and found it really helpful.  having never done anything to do with macros before it got me where I wanted.

The updated time column was a bonus feature i didnt even know existed.

The stumbling block I now have is within one worksheet I want three different locked timestamp columns that share one updated time column.  is this possible?

If not is it possible to have three sets of fixed timestamps with their own updated time columns within the same worksheet?

are any of these things possible and if so how would i set this up.

I'm using Excel 2010
Njones Dec 7, '19 at 8:47 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login