Automatically move data from one sheet

Closed
bustosjuan Posts 1 Registration date Wednesday April 11, 2018 Status Member Last seen April 11, 2018 - Updated on Apr 12, 2018 at 04:46 AM
 Blocked Profile - Apr 12, 2018 at 05:20 PM
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:
Sheet1
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 response

Blocked Profile
Apr 12, 2018 at 05:20 PM
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:

https://ccm.net/forum/affich-1042041-copy-data-in-one-worksheet-to-another-vba#p1042596

0