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
* 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 reverse order > > ** ** > > Hi, > > ** ** &g

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

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

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

2012-03-19 Thread Amit Desai (MERU)
Hi, Is there any formula to copy data from say 2 rows say 1 & 2 & paste them in reverse order. Data of 1st row will move to 2nd & of 2nd row to first.. Best Regards, Amit Disclaimer: This message and its attachments contain confidential information and may als