View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
 
Posts: 364
Default 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.