-
Mirroring of sheets to a single summary sheet
Hi I am new to VBA just getting my bearings with it.
I am looking to create a summary sheet for a workbook that has various sheets.
The data in each sheet is mainly text.
I would like the summary sheet to mirror all the data that is in each of the separate sheets so that if any changes are made both change.
I currently have it coded so that my summary sheet clears then the sheets are copied and pasted on to it again when I click an active x button. This is working as a temporary fix but wondered if there was a neater way to do it.
Like I said very new to this so any help would be greatly appreciated.
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules