![]() |
Sync parts of two worksheets including formats
I am looking for a way to have a primary and secondary worksheet. I will
make changes to the primary and want those mirrored on the secondaary sheet. I want o mirrow all changes, formatting, adding, deleing rows, columns, etc., not just the data. I know how to use the change event to mirror the data but no help for the other things. I also know how to use the Sheets(array(....)).select to link the two but this mirrors the entire sheets and I just want to mirror a section of the sheets say A1:F1000 and the rest is unique to each sheet. Anyone have a solution. |
All times are GMT +1. The time now is 05:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com