Mr Robert,
It's not clear why you want the same data in the same sort order on two
sheets . If that is how you want it, I believe you want the changes as and
when you do on sheet 1, it should automatically appear on sheet 2 in the same
way. If my understanding is correct, you can try the following:
i) go to one cell of your choice on sheet 2
ii) type " ="
iii) go to sheet 1 and select the first cell of your table
iv) Press enter
In the cell selected by you in sheet 2 , you will find the value of the
first cell of your data table on sheet 1
v) Now copy the contents of cell in sheet 2 to as many cells to the right as
well as down as you have data on sheet 1 (or you may have in more rows if you
choose to, if you feel the data on sheet 1 will increase over time)

As and when you make changes in sheet 1 ( including data sorting ), the
changes will be reflected in sheet 2 as it they are on sheet 1.

If you want to process the data on sheet 2 differently after the changes in
sheet 1, you may have to copy the entire range of data on sheet 2 and using
paste special convert them into mere values. The link with sheet 1 will
however get snapped by this process.
Hope this is useful.

Best Wishes

"Robert N" wrote:

Thanks I thought it might be kind of easy.

Rob

"JW" wrote:

So you want the same sort on each sheet, correct? Simply hold down
the Ctrl key, select both sheet tabs, perform your sort on sheet 1,
right click on the selected sheets and select Ungroup Sheets. Just be
certain that you ungroup the sheet or any changes that you make in one
sheet will be automatically made (possibly overwtiring data) in the
other sheet. Or, you can replace the data in sheet 2 with reference
formulas to sheet1. But you may find yourself adding formulas when
the data in sheet1 grows.
Robert N wrote:
I have another formula question for excel users. What i am doing is making a
spread sheet. On the first sheet i have the names of people on staff with
their sales. i copied those names and sales over to the next sheet. But on
the first sheet i want to put those names and sales in ascending order
according to sales, which i understand how to do. I want name and sales on
sheet 2 to adjust in acending order when i ascend sheet one. I hope i
explained this well enough for people to understand.

Thanks
Rob