Re: $$Excel-Macros$$ copy paste in reverse order

2012-03-20 Thread Shaik Waheed
cial pasting! >> >> ** ** >> >> Best Regards, >> >> Amit >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI >> *Sent:* 20 March 2012 11:44 &g

Re: $$Excel-Macros$$ copy paste in reverse order

2012-03-20 Thread NOORAIN ANSARI
; ** ** > > Best 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-Macr

RE: $$Excel-Macros$$ copy paste in reverse order

2012-03-20 Thread Amit Desai (MERU)
: 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, &qu

Re: $$Excel-Macros$$ copy paste in reverse order

2012-03-19 Thread NOORAIN ANSARI
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) wrote: > Hi, > >

Re: $$Excel-Macros$$ copy paste in reverse order

2012-03-19 Thread Maries
Hi, PFA. =OFFSET($A$1,ROW($A$20)-ROW(),0) Regards, MARIES. On Mon, Mar 19, 2012 at 8:52 PM, Rajan_Verma wrote: > See the attached File > > ** ** > > =INDEX($A$1:$A$20,COUNTA($A$1:$A$20)-ROW()+1,1) > > ** ** > > Rajan. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > e

RE: $$Excel-Macros$$ copy paste in reverse order

2012-03-19 Thread Rajan_Verma
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 rever

Re: $$Excel-Macros$$ copy paste in reverse order

2012-03-19 Thread Venkat CV
Hi Amit, Try Transpose Option on Paste special..if Helps.. *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Mon, Mar 19, 2012 at 6:02 PM, Amit Desai (MERU) wrote: > Hi, > > ** ** > > Is there any formula to copy data from sa