Sorting

[Bobby]

1st Thanks for reading/helping, I sure can't get this to work.

I have a group of numbers on sheet 1, these numbers are then sent over
to sheet #2 and sorted. I want these numbers to be resorted when I go
from sheet 1 to sheet 2 automatically
As of now when I change sheets I have to manually resort the numbers
with the sort command.

Thanks Bobby

 

[RagDyeR]

How do you "send" the numbers to Sheet2?

If you had a simple linking formula on Sheet2 that "pulled" the numbers from
Sheet1 (i.e. =Sheet1!A1), then you could try this in a "helper" column,
where this formula would *display* the numbers of the "pulling" column in
ascending order:

=SMALL($A$1:$A$10,ROW(A1))

And copy down.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


1st Thanks for reading/helping, I sure can't get this to work.

I have a group of numbers on sheet 1, these numbers are then sent over
to sheet #2 and sorted. I want these numbers to be resorted when I go
from sheet 1 to sheet 2 automatically
As of now when I change sheets I have to manually resort the numbers
with the sort command.

Thanks Bobby