ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sync parts of two worksheets including formats (https://www.excelbanter.com/excel-programming/443124-sync-parts-two-worksheets-including-formats.html)

Steve[_118_]

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