Hi,
Why not =Sheet1!A1 and then copy down and right
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Sparrkky" wrote in message
...
Worksheet 1 has data that will always stay in there appropriate cell
address
and be available for only one person to update. Worksheet 2 will be a copy
of
Worksheet 1 but only used to sort by criteria in a given column and only
be
used for sorting purposes by more than one person. Any data that is
changed
in Worksheet 1 will automatically change the data in Worksheet 2.
How can I accomplish this? The "=Sheet1!$A$1" function is not feasible
since
I am over 150 columns wide and at least 1000 rows deep. I am sure there is
some other way to accomplish this task!