Copy data to a master sheet from newly created sheet
Closed
Wraggy
-
17 Sep 2019 à 12:21
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 24 Sep 2019 à 11:46
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 24 Sep 2019 à 11:46
Related:
- Copy data to a master sheet from newly created sheet
- How to copy data from one excel sheet to another - Guide
- Little alchemy cheat sheet - Guide
- Excel move data from one sheet to another - Guide
- How to copy data to multiple worksheets in Excel - Guide
- Create new sheet vba - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
24 Sep 2019 à 11:46
24 Sep 2019 à 11:46
Hi Wraggy,
That would mean that every sheet other then the Master would have code and that for every new sheet you would have to add the code to it.
Why not input your data in the Master sheet and let a single code update your sub sheets.
Have a look at the following How-To to see how that is done:
https://ccm.net/faq/55882-how-to-auto-transfer-data-from-master-to-sub-sheets-in-excel
If you need further assistence, then provide more details, like range and sheet references, to know which data needs to go where and at what moment.
Best regards,
Trowa
That would mean that every sheet other then the Master would have code and that for every new sheet you would have to add the code to it.
Why not input your data in the Master sheet and let a single code update your sub sheets.
Have a look at the following How-To to see how that is done:
https://ccm.net/faq/55882-how-to-auto-transfer-data-from-master-to-sub-sheets-in-excel
If you need further assistence, then provide more details, like range and sheet references, to know which data needs to go where and at what moment.
Best regards,
Trowa
