Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I link all worksheets so that a chg in one will change all
Excel 2007: I need to have about 6 worksheets, all the same data, but all
sorted differently & need to reference them often. How to I link all 6 so that any changes to one will change them all? Note this is in Office 2007. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I link all worksheets so that a chg in one will change all
If you have your data in Sheet1 then go to Sheet1 Cell A1
and type =Sheet1!A1 and copy down and across till you get all your data as in Sheet1 You can then select the whole of Sheet2 and copy in Sheet3, 4,... You can then sort your sheets as you please... "MarciaPhx" wrote: Excel 2007: I need to have about 6 worksheets, all the same data, but all sorted differently & need to reference them often. How to I link all 6 so that any changes to one will change them all? Note this is in Office 2007. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link to other worksheets | Excel Discussion (Misc queries) | |||
how to link worksheets | Excel Worksheet Functions | |||
Link worksheets | Excel Discussion (Misc queries) | |||
how to link worksheets | Excel Worksheet Functions | |||
How do I Link two worksheets? | Excel Worksheet Functions |