Hi there all,
I am needing to be able to see if there is a "NO" in Column C - On Worksheet "Audit"
If there is then I need to COPY the ROW from A? to D? (whatever row number "No" is on)
Then I need to Paste that info onto Worksheet "Non Compliant" Starting at A4 to D4 and then continue to the next "NO" and do the Same.
EXAMPLE
Worksheet "AUDIT"
(Row No.) A B C D
1 Clause No Requirement Compliant Notes
2 2.3 This is a great place. Yes
3 2.3.1 I am stuck here lol. No
4 2.3.1 b) Now to type more. N/A
So looking at COLUMN "C" I can see ROW "3" has a "NO" in the Compliant spot. So what I need to happen is for the system to Copy A3 to D3 and Paste it into the Worksheet "Non Compliant"
Starting at A4
I will need this to keep looking through the Data and if there are any other "NO" answers then the ROWs involved need to be copied to the Worksheet "Non Compliant"
I do hope that this is as clear as mud and if you need any more info Please leave me a message as I will be checking it from time to time, But I am in Australia which is GMT +10 so that's the time difference.
Thanks in Advance for any help will be really appreciated.
Regards
Gordon
Bookmarks