Copy Specific Cells in All Active Worksheets to Summary Sheet

[TweetyS]

Hi,
Completely new to VBA so all help much appreciated. I am attempting to write a macro to copy specific cells (ie B2, B4, G6, H22) from all active worksheets in a workbook (the number of worksheets will increase through time) and paste the values into a summary sheet called ‘Register’ in the same workbook. I would like the macro to delete all entries in the Register initially then copy the values from all current worksheets.
I have tried a few that I found online but cannot get them to work.
All help is much appreciated.

Example spreadsheet now attached.

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post

[sintek]

Hi TweetyS

Welcome to the forum...
Give this a go...Not sure of G6...Has no value so for this exercise I used B6...

Please Login or Register  to view this content.

[mjr veverka]

Another example, with pre-sorting of sheets:

Please Login or Register  to view this content.

[sintek]

Thanks for rep...Does this solve?

[TweetyS]

Works perfectly. You're a star!!!
Thanks 😇😇

[sintek]

Pleasure, pls mark thread as solved

[TweetyS]

Can you tell me how to do that? On phone as I've discovered my work pc lets me post but settings won't let me reply. Thanks again 😊

[sintek]

Top of post...Thread Tools..."Mark as Solved"