Auto fill in and update current date and time whenever certain cells are filled

[Danisioni]

Excel sheet-testing 7.xlsx
	A	B	C	D	E	F	G
1	DAY	DATA					DATE/TIME
2	DAY 1	cell B2	cell C2	cell D2	cell E2		cell G2
3	DAY 2						auto-fill dd/ hh:mm:ss
4	DAY 3						auto-fill dd/ hh:mm:ss
5	DAY 4						auto-fill dd/ hh:mm:ss
Testing 2

Hi, can anyone help me get this done?

I need Excel to automatically FILL-IN and UPDATE the current Date & Time (dd/ hh:mm:ss) in cell G2, whenever any of the "DATA" cells (B2 to E2) in row 2 (Day1) is FILLED, (regardless of whether one of the other cells in the same row has already been filled).
Note 1: The same should apply for each of the rows below (day 2, day 3.. and so on infinitely).
Note 2: Filling or updating the "DATA" cells from one of the rows should NOT change/update the "DATE/TIME" cell from the other rows (above or below).
Note 3: If all the "DATA" cells of one row are empty then also the DATE/TIME cell of that row will remain empty.

Thanks

 

[Danisioni]

That was my mistake, corrected here I hope.

Manually correcting the time works now. Thanks!

Suppose cell F6 is blank on day 1, filled in with a value on day 2, cleared on day 3 and a value entered on day 4. Do you consider F6 to be filled in for the first time on day 4 or not?

This scenario is highly unlikely.
let’s take a step back.

Here is what would work for me:
1. I need the Date/Time cell to fill in the time whenever one new empty Data cell is filled for the first time (what happens to that cell after that does not matter. The time is freezed).
2. I should be able to edit a value in one of the filled cells (in case I mistakenly filled-in the wrong number) without the time updating.
3. Deleting a cell is unlikely, but in case that happens I would like that the time remains unchanged as well.
4. If ALL cells of that day are empty or go empty as a result of deleting one or more cells then the Date/Time cell will obviously be empty too.

Let me know if you have more questions.

In relation to undo, any work-around I think would be very difficult.

Ok.

In relation to match formatting, if the formatting in columns E:H is uniform and you always want to "match destination formatting" then the code could do that, either ..
- by copying the formatting from a dummy hidden row, or
- by applying the various formatting components directly, or
- as I mentioned before, use Paste Special - Values in the first place

Yes I always want to "match destination formatting.
I tried “Paste Special” - It does not show me "Value". It shows me: “HTML”, “Unicode text” and “Text”. - "Text" seems to do the trick.
I also tried changing formats and adding conditional formatting and everything seems to work well without creating problems to the code or the sheet.

If you want to keep all the paste options available after the paste has taken place then I don't think that will be possible with the code

Thats ok, I will use the "Paste Special" option.

Thanks again.