Help wanted with VBA code
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
|