Update Master / Summary Tab with all new entries in other sheets / tabs

Report
Posts
3
Registration date
Wednesday November 13, 2019
Status
Member
Last seen
November 14, 2019
-
TrowaD
Posts
2599
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 24, 2020
-
Hello,

I have a workbook with 9 worksheets; one of the sheets is the master; created to be the other 9 sheets compiled into 1. I need to set it up so that any new data entered into the new separate sheets is automatically entered into the master sheet, in the first blank row.

It'd be great to add a "Run" button to refresh updates. Please also advise as to how to add more tabs if need be. I have no experience with VBA/macros.

Thanks in advance for any help.

1 reply

Posts
2599
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 24, 2020
401
Hi Santosjo,

Consider using your Master sheet as your input sheet. That way you only have to implement 1 code and you can add as many sheets as you want. Otherwise you will have to create a button and implement a code for each sub sheet.

Read through the following How To:
https://ccm.net/faq/55882-how-to-auto-transfer-data-from-master-to-sub-sheets-in-excel

Let us know how this works out.

Best regards,
Trowa

santosjo
Posts
3
Registration date
Wednesday November 13, 2019
Status
Member
Last seen
November 14, 2019

Thank you. Think you could help directly if I provide a test workbook?
santosjo
Posts
3
Registration date
Wednesday November 13, 2019
Status
Member
Last seen
November 14, 2019

And I agree. More so a refresh button on the summary tab
TrowaD
Posts
2599
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 24, 2020
401
Hi Santosjo,

If you read through the link provided and still need assistance, you can upload your test workbook using a free file sharing site like http://ge.tt and then post back the download link provided.

Best regards,
Trowa