Related:
- Copy data to a master sheet from newly created sheet
- How to pull data from a master sheet in excel - How-To - Excel
- Excel - Copy data from a range of sheets to a master sheet - How-To - Excel
- Macro Help: Copy Data from a Range of Sheets to a Master Sheet ✓ - Forum - Excel
- How to copy data from one excel sheet to another - How-To - Excel
- How to map data in two excel sheets - How-To - Excel
1 reply
TrowaD
- Posts
- 2693
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- January 18, 2021
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
Subscribe To Our Newsletter!
