Copy cell value in one column if conditions is met

You have formulas in column B. Do you want to destroy them by inserting a constant value?

Artik

Hi Artik, thank you for your concern.

It honestly doesn't matter if the formula is being destroyed in the particular cell. As long as it only applies when the column I is marked with an "X"

Of course, I need the formula to work on the following cells aswell.

After thinking about it, the Worksheet_Change event (plus RestoreFormulas sub) took the form of:

Please Login or Register  to view this content.

Some comments.
1. The formula in column B has changed, as it did not provide for two characters if you selected item #10 in column D.
2. I changed the formula text in column G to be a little simpler. The formula should be improved by changing ??? to the correct text (applies when item #10 is selected in column D). Similarly, you should create formulas in column Q.
3. I changed the content of the Timestamp function to:

Please Login or Register  to view this content.

The Format function used earlier (Timestamp = Format(Now,"dd-mm-yyyy") ) caused that text resembling a date was inserted into the cell, not the date as a number. If in a cell you want to see a date format other than your system's, the format should be forced in the cell, not in the function!
4. If the H column is to contain the date at the time the record was entered, I think that the Timestamp function should not be used in it. This macro should insert the current date. Let me give you an example. If you have a record in the table where column H is earlier than the current date, changing the value in column C will convert the Timestamp function and insert the current date. And it should be unchangeable.

The task may seem easy, but things get complicated when the user does not act according to our expectations. We are not able to predict all his behaviors on the sheet.

Artik

Thank you so much Artik
I really appreciate your great help.

Regarding Timestamp: So maybe that's why all cells that contain timestamp are updated when I open the excel sheet via Sharepoint?

So the more the current use of the Timestamp function should be replaced with the code in the Worksheet_Change event, which will insert the current date where the function was used.

Artik