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

Closed
santosjo Posts 3 Registration date Wednesday November 13, 2019 Status Member Last seen November 14, 2019 - Updated on Nov 14, 2019 at 10:50 AM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Nov 18, 2019 at 11:27 AM
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

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Nov 14, 2019 at 11:58 AM
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

0
santosjo Posts 3 Registration date Wednesday November 13, 2019 Status Member Last seen November 14, 2019
Nov 14, 2019 at 01:08 PM
Thank you. Think you could help directly if I provide a test workbook?
0
santosjo Posts 3 Registration date Wednesday November 13, 2019 Status Member Last seen November 14, 2019
Nov 14, 2019 at 01:09 PM
And I agree. More so a refresh button on the summary tab
0
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Nov 18, 2019 at 11:27 AM
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
0