At the moment i am working two tabs in excels and i have to update of the tab manually.


I am looking for way a that if work in sheet 1 it updates sheet two automatically but with conditions. The updates should only take place if the D1 cell is marked "X".
If the D1 cell is marked "X" then in sheet two the A1 cell should be updated with the cell value B1 mentioned in sheet one