ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Mirror formating changes in seperate worksheet (https://www.excelbanter.com/excel-worksheet-functions/214701-mirror-formating-changes-seperate-worksheet.html)

Biff

Mirror formating changes in seperate worksheet
 
I'm not sure if there is a function for this, but I have two worksheets that
will having the same core structure (same column headings and rowing
headings, but different data). I want to know if there is a way that if I
add a row in the second worksheet. Any help?

Shane Devenshire

Mirror formating changes in seperate worksheet
 
Hi,

You question is not complete? You can always add a row in a second
worksheet, just right click the row number and choose Insert.

If you want the have changes you make to one sheet duplicated in another
then hold down the Ctrl key and select all the sheets you want to change.
You will be in group mode and anything you do to one of the selected sheets
gets done to all. Be careful, when you are finished remember to ungroup the
sheets - right click a sheet tab and choose Ungroup.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Biff" wrote in message
...
I'm not sure if there is a function for this, but I have two worksheets
that
will having the same core structure (same column headings and rowing
headings, but different data). I want to know if there is a way that if I
add a row in the second worksheet. Any help?




All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com