Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I have med a worksheet with a lot of changes - CAN excel be set up too when i press make a new worksheet the new worksheet will be like the ohter worksheet with all the changes in ???? and I also need it to be - when I have lets say 20 worksheet I only need to make changes too one worksheet then it will change on them all Please help /per |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can use Edit|move or copy sheet to copy a sheet that's set up the way you
want. And if you have headers that are common across all the sheets, you could use a formula on the "receiving" sheets: =sheet1!a1 But I've only see this work effectively with stuff that doesn't change--row and column headers mostly. Per wrote: Hi I have med a worksheet with a lot of changes - CAN excel be set up too when i press make a new worksheet the new worksheet will be like the ohter worksheet with all the changes in ???? and I also need it to be - when I have lets say 20 worksheet I only need to make changes too one worksheet then it will change on them all Please help /per -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Making a worksheet a templete | Excel Discussion (Misc queries) | |||
Making Negative Results Default to Zero | Excel Discussion (Misc queries) | |||
Making Find go through worksheet only once | Excel Discussion (Misc queries) | |||
help! making a worksheet more automated? | Excel Discussion (Misc queries) | |||
Track Changes: Making "All" the default | Excel Discussion (Misc queries) |