Auto Transfer questioner with right answer to another sheet
Closed
Fairuz
-
Jun 29, 2019 at 12:51 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 1, 2019 at 11:46 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 1, 2019 at 11:46 AM
Related:
- Auto Transfer questioner with right answer to another sheet
- Free fire transfer - Guide
- Google sheet right to left - Guide
- How to answer call with volume button android - Guide
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- How to stop facebook auto refresh - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jul 1, 2019 at 11:46 AM
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
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
