Copy data to a master sheet from newly created sheet [Closed]

Question

Copy data to a master sheet from newly created sheet [Closed]

Report

Wraggy - Sep 17, 2019 at 12:21 PM
TrowaD

Posts: 2718
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: April 15, 2021

- Sep 24, 2019 at 11:46 AM

Hello,

I have a master sheet that I want to automatically fill.
I have a macro that creates a new sheet for each instance, I now need another to copy data that is inputted into that new sheet that will update a master sheet without having to copy and build the functions each time.

System Configuration: Windows / Firefox 69.0

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

Ask a question

TrowaD · Answer 1 · 2019-09-24T11:46:05-0400

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

Copy data to a master sheet from newly created sheet [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!