:
excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
*Sent:* 20 March 2012 11:44
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ copy paste in reverse order
** **
Dear Amit,
you can also try through VBA..
Sub reverse_order()
Dim i
Dear Amit,
you can also try through VBA..
Sub reverse_order()
Dim i, rw As Integer
rw = Cells(Rows.Count, A).End(xlUp).Row
For i = 1 To rw
Cells(i, B).Value = Cells((rw + 1) - i, A)
Next i
End Sub
See attached sheet.
On Mon, Mar 19, 2012 at 6:02 PM, Amit Desai (MERU)
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy paste in reverse order
Dear Amit,
you can also try through VBA..
Sub reverse_order()
Dim i, rw As Integer
rw = Cells(Rows.Count, A).End(xlUp).Row
For i = 1 To rw
Cells(i, B).Value = Cells((rw + 1) - i, A)
Next i
End Sub
See
Regards,
Amit
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
*Sent:* 20 March 2012 11:44
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ copy paste in reverse order
** **
Dear Amit
Hi Amit,
Try Transpose Option on Paste special..if Helps..
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Mon, Mar 19, 2012 at 6:02 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Hi,
** **
Is there any formula to
See the attached File
=INDEX($A$1:$A$20,COUNTA($A$1:$A$20)-ROW()+1,1)
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amit Desai (MERU)
Sent: Mar/Mon/2012 06:03
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ copy paste in
Hi,
PFA.
=OFFSET($A$1,ROW($A$20)-ROW(),0)
Regards,
MARIES.
On Mon, Mar 19, 2012 at 8:52 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
See the attached File
** **
=INDEX($A$1:$A$20,COUNTA($A$1:$A$20)-ROW()+1,1)
** **
Rajan.
** **
*From:* excel-macros@googlegroups.com