Re: $$Excel-Macros$$ Paste Vertically

2013-05-15 Thread Prabhakar S H
Hi Amit, Great i got new short cut to transpose database. can you send me all the excel advance short cut keys. Rgds, Prabhakar On Tuesday, May 14, 2013 4:19:55 PM UTC+5:30, Amit Desai (MERU) wrote: > Do Copy & then do Alt E S V E. > > > > Best Regards, > > Amit Desai > > +91 98672 32534

Re: $$Excel-Macros$$ Paste Vertically

2013-05-14 Thread Abhishek Jain
Hi Prafull, I think you got the wrong message. I never said VBA is better. I just said a task can be accomplished in many ways. My first message was a VBA solution and second one was without VBA. Besides, while generalizing a topic, I suggest you don't keep the group in copy. I always have, and w

Re: $$Excel-Macros$$ Paste Vertically

2013-05-14 Thread Prafull Jadhav
Dear Abhishk Sir , I have also me the same without VBA ...just for example. I know VBA is better way . On Tue, May 14, 2013 at 5:43 PM, Chaya wrote: > Hi Priti, > > Thank you. your formula contains logic a lot, perfectly working. thanks > once again. > > > Regards, > Chaya > > The excel l

Re: $$Excel-Macros$$ Paste Vertically

2013-05-14 Thread Chaya
Hi Priti, Thank you. your formula contains logic a lot, perfectly working. thanks once again. Regards, Chaya The excel learner :-) On Tue, May 14, 2013 at 5:34 PM, priti verma wrote: > Hi Chaya , > PFA, > without vba > If it helps > > > On Tue, May 14, 2013 at 4:11 PM, Chaya wrote: > >>

Re: $$Excel-Macros$$ Paste Vertically

2013-05-14 Thread priti verma
Hi Abhishek, I understand and agree. On Tue, May 14, 2013 at 5:45 PM, Abhishek Jain wrote: > Another simplified way. Without having to transpose. Requires a bit of > other work though. > > There is always more than one way to get a result. This is just for the > sake of learning. Hope you don'

Re: $$Excel-Macros$$ Paste Vertically

2013-05-14 Thread Abhishek Jain
Another simplified way. Without having to transpose. Requires a bit of other work though. There is always more than one way to get a result. This is just for the sake of learning. Hope you don't mind Priti. Regards, Abhishek On Tue, May 14, 2013 at 5:34 PM, priti verma wrote: > Hi Chaya , > P

Re: $$Excel-Macros$$ Paste Vertically

2013-05-14 Thread priti verma
Hi Chaya , PFA, without vba If it helps On Tue, May 14, 2013 at 4:11 PM, Chaya wrote: > > Dear experts, > > I have set of data which need to be copy and paste in vertical way. I > have more than thousand columns, So very taugh to copy and paste one by > one. > > I have attached the f

Re: $$Excel-Macros$$ Paste Vertically

2013-05-14 Thread Chaya
t; Amit Desai > > +91 98672 32534 > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Chaya > *Sent:* 14 May 2013 16:24 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-

RE: $$Excel-Macros$$ Paste Vertically

2013-05-14 Thread Amit Desai (MERU)
Please share the main sheet.. I will convert it & send it... Best Regards, Amit Desai +91 98672 32534 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chaya Sent: 14 May 2013 16:24 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ P

Re: $$Excel-Macros$$ Paste Vertically

2013-05-14 Thread Abhishek Jain
Understand transpose won't work for your query. Try this. Regards, On Tue, May 14, 2013 at 4:24 PM, Chaya wrote: > Thanks Amit, > >But i don't want to transpose the datas, please see the attachment. > > > > Regards, > Chaya > > The excel learner :-) > > > On Tue, May 14, 2013 at 4:19 PM,

Re: $$Excel-Macros$$ Paste Vertically

2013-05-14 Thread Chaya
Thanks Amit, But i don't want to transpose the datas, please see the attachment. Regards, Chaya The excel learner :-) On Tue, May 14, 2013 at 4:19 PM, Amit Desai (MERU) wrote: > Do Copy & then do Alt E S V E. > > ** ** > > Best Regards, > > Amit Desai > > +91 98672 32534***

RE: $$Excel-Macros$$ Paste Vertically

2013-05-14 Thread Amit Desai (MERU)
Do Copy & then do Alt E S V E. Best Regards, Amit Desai +91 98672 32534 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chaya Sent: 14 May 2013 16:12 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Paste Vertically Dear experts, I have