Previous Topic Next Topic

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

Closed
santosjo Posts 3 Registration date Wednesday 13 November 2019 Status Member Last seen 14 November 2019 - 13 Nov 2019 à 11:02
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 18 Nov 2019 à 11:27
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.
Related:

1 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
14 Nov 2019 à 11:58
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 13 November 2019 Status Member Last seen 14 November 2019
14 Nov 2019 à 13:08
Thank you. Think you could help directly if I provide a test workbook?
santosjo Posts 3 Registration date Wednesday 13 November 2019 Status Member Last seen 14 November 2019
14 Nov 2019 à 13:09
And I agree. More so a refresh button on the summary tab
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
18 Nov 2019 à 11:27
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