Menu
Ask a question Report

Auto Transfer questioner with right answer to another sheet

- - Latest reply: TrowaD
Posts
2519
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 3, 2019
 - Jul 1, 2019 at 11:46 AM
Excel Ask a question Report
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..
See more 

1 reply

Report Respond to TrowaD
Posts
2519
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 3, 2019
 361
0
Thank you
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
Respond to TrowaD
Reply Ask a question