Automatically move data from one sheet

Registration date
Wednesday April 11, 2018
Last seen
April 11, 2018
 Blocked Profile -
How to automatically move/copy data from one sheet to another if certain criteria met.
Hi. I have two sheets, sheet1 I have data where each cell has 3 diferent values (0, 1 or N/A)
I want to transfer any data in Sheet1 whose value change to "0". For example:
Code Permits/Authorizations Used 0%
0101 Part A Work details 0
0102 Part B Work scope & description N/A
0103 Part C Specialty safety equipment N/A
0104 Part D Safety precautions N/A
0105 Part E Work authorization N/A
0106 Part A Work details N/A

all cells in colum 1 and 2 are conditional formated to change to red when selection in colum 3 is "0".

I want to transfer automaticaly ONLY any data in sheet1 whose value change to "0" in colum 3, and tranfer all data defined as "0" to another sheet (Sheet2). I do not konw how to do it. Some one could help me with this, please?

Could someone hwlp me on this, please?

1 reply

So what part of your code are you stuck on? POst some code here and we can help.
Perhaps you need to look at this: