reverse order

sheet1
A B C
anil kumar G
kiran Nair
murali Menon M
Keerthana Nair S

i need to revers these
the result like below reverse only A1 to C4 and will not affect other ranges
A B C
Keerthana Nair S
murali Menon M
kiran Nair
anil kumar G

Originally Posted by :) Sixthsense :)

Formula:

Please Login or Register  to view this content.

Drag it down and right...

thanks but i need the code as macro

I cant find advanced > manage attachments>> manu for attachment

Pls find sample attachment result in sheetb

need code as macro

sorry dear
i cant get the correct answer and also lose some date while running the macro
i once again add a sample file for review

Working.....

it is not working with my second sample file


one more is it possible to specify the range H3:S8 for revise at ur code because normally the destination start from h3 and upto end.
destination is also the same sheet same range
could u pls help

Please Login or Register  to view this content.

hello dear
thanks for ur suggestion and code
it work perfectly but the problem is is reverse the entire row means it start from A range
i need to revers range("H:S") that i mentioned before

we refer the starting range
With Sheets("sheet1").Range("h3").CurrentRegion
but why it take the entire row

can u help to change to reverse it only with in the range ("H:S")

Post EXACT same workbook.

Originally Posted by anilg0001

here u can find that A3 not equal to h3
and a3 equal to h102
so i need to revise the data of H3 to S102 then only
a3 = h3
a50=h50
a102=h102
pls review

What are you trying to do?

It seems you are asking completely different question from your original.

dont bother about other thing
just reverse h3:s102 here and all others are constant.

through revise h3:s102 then i can just match with the data of "A" range
u can compare there with name field

h and a ranges are NAMES
ONLY REVISE I CAN MATCH THEM
THANK U DEAR

Please review the newsample file then u can understand it easily

because i am not much femilier with english
thank u dear

No, you are not clear to me and changing the situations, so I'm out.

Wait for someone else to come in.