hi


i was able to solve the hard part that is getting to sort now i want to
link sheet two values with sheet one and again sort can anyone help me
eith the linking



thanks in advance


indraneel
wrote:
the problem that i have infront of me is something like this


I have a set of data that i get from analyses

it is a 15 page data that is pasted in excel

each page contains 10 entries in 1 column say EID element id

the data would look like
COLUMNS
EID A B C D E F G H I J K
123456
1 2 3 4 5 6 7 8 9 5 6
2 3 6 7 8 9 1 2 6 5 4
5 6 8 9 1 3 4 5 6 5 2
23564
1 2 3 4 5 6 7 8 9 5 6
2 3 6 7 8 9 1 2 6 5 4
5 6 8 9 1 3 4 5 6 5 2

AND SO ON

ok now what i want to do is sort by column K say(Descending) then want
the highest value to be displayed with the Element Id
so that i can move them to a new sheet where i can again sort the same
for say col K again


i was able to do it for 1 Page that is 10 values but i used the Record
Macro button but i dont see it as a good way to go and so wanted to see
how can i do it using do or if command and within it a sort command
that selects the on screen value


thank you in advance

regards
indraneel


@ BOB YOU HAVENT = ??????
Bob Phillips wrote:
You haven't!

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
i want to write a macro
that would contain a do loop
and within that do loop i want to do sorting

can any one help i cant understand of how to select the cells that i
want to sort in VBA language


hope i have made my self clear

thanking you in advance


regards
indraneel