Auto Transfer questioner with right answer to another sheet

Closed
Fairuz - Jun 29, 2019 at 12:51 AM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Jul 1, 2019 at 11:46 AM
Hello,

I have questioner list (yes or no) about 60question. I want to make it automatically transfer (all the row) to another sheet if answer is ‘No’. I want to make it 1report and only for ‘no’ answer.

TQ..

1 reply

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Jul 1, 2019 at 11:46 AM
Hi Fairuz,

Have a look here:
https://ccm.net/faq/55882-how-to-auto-transfer-data-from-master-to-sub-sheets-in-excel

Change "Yes" to "No" on the 6th code line and change "Sheets(Target.Offset(0, -1).Value)" to "Sheets("YourSheetNameHere")" on the 8th code line. Also check the column references.

Best regards,
Trowa
0