Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 57
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 857
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicating/Mirror Data into another worksheet within same workboo TJ Excel Worksheet Functions 1 May 6th 08 09:39 AM
How do I have seperate headers for seperate pages in 1 worksheet? JessicaDL Excel Discussion (Misc queries) 1 February 22nd 08 07:14 PM
Mirror Columns accross worksheet dangerd Excel Discussion (Misc queries) 6 January 25th 08 05:59 PM
Wanted: Worksheet Tabs that "mirror" the first few columns of Pre Jack&Jill Excel Discussion (Misc queries) 0 January 4th 08 08:47 PM
Chart in seperate worksheet Jay Charts and Charting in Excel 3 October 19th 06 08:43 PM


All times are GMT +1. The time now is 01:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"