Re: $$Excel-Macros$$ Need macro help

2015-03-07 Thread Vaibhav Joshi
,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Prabhu Pinky > *To:* excel-macros@googlegroups.co

Re: $$Excel-Macros$$ Need macro help

2015-03-05 Thread Paul Schreiner
nt: Thursday, March 5, 2015 10:37 AM >Subject: Re: $$Excel-Macros$$ Need macro help > > > >Hi paul, thanks for your response. Since i have some basic knowledge in vba >macro..if you share any macro related to my query i can modify that and >develop for my requirement.. That

Re: $$Excel-Macros$$ Need macro help

2015-03-05 Thread Prabhu Pinky
Hi paul, thanks for your response. Since i have some basic knowledge in vba macro..if you share any macro related to my query i can modify that and develop for my requirement.. That will help for me.. On 05-Mar-2015 8:51 PM, "Paul Schreiner" wrote: > try searching in the user group. > There shoul

Re: $$Excel-Macros$$ Need macro help

2015-03-05 Thread Paul Schreiner
try searching in the user group. There should be several projects similar to this recently. since your question wasn't specific, it sounds like you're able to modify the vba code yourself, so the previous examples should be sufficient to get you started. If you need additional help, please pr

Re: $$Excel-Macros$$ Need Macro help to copy paste the each column data in one column

2011-05-10 Thread ashish koul
attach the sample file On Mon, May 9, 2011 at 7:21 PM, vinu wrote: > Hello team, > > Could you please help me for the below scenario: > > Need a code to copy paste column data under one column and keep the > same description. > > A B C > >bangmysore > > jan 645

Re: $$Excel-Macros$$ Need macro help to copy paste each column data under one column

2011-05-10 Thread ashish koul
change sheet3 name as out and tun the macro Sub swa() Dim i, SW, swa As Long SW = Sheets("input").Range("A65356").End(xlUp).Row For i = 2 To Sheets("input").Range("b6").End(xlToRight).Column Sheets("input").Activate Sheets("input").Range("a8:a" & SW).Copy swa = Sheets("out").Range("b65356"

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

2010-05-26 Thread Paul Schreiner
_________ From: Erick C To: MS EXCEL AND VBA MACROS Sent: Tue, May 25, 2010 12:42:24 PM Subject: Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste Paul - I changed the part of the code that you suggested, and it is working fine. Again, I am still quite a novice with

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

2010-05-26 Thread Manas Adhikary
Dear All, I want to Print Page Number "N of M" in Footer by Group-wise (i.e. ID Wise) through Access Database Report Design. Kindly give some guideline or VB Code to do the same. Rgds, Manas. -- -- Some important lin

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

2010-05-25 Thread Erick C
hrough to see what it is doing. > > You should find the problem then. > > sorry for the confusion (and sarcasm) ;) > > Paul > > > From: Erick C > To: MS EXCEL AND VBA MACROS > Sent: Mon, May 24, 2010 3:41:51 PM > Subject: Re: $$E

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

2010-05-25 Thread Paul Schreiner
_________ From: Erick C To: MS EXCEL AND VBA MACROS Sent: Mon, May 24, 2010 3:41:51 PM Subject: Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste Hi Paul - I tried the code you provided without making any modifications and I had a few issues. Just for a bit of background: 

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

2010-05-24 Thread Erick C
A MACROS > Sent: Fri, May 21, 2010 11:55:43 AM > Subject: Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste > > Hi Paul - > Thanks for the reply.  Let me attempt to answer your questions and > hopefully clarify a bit. > 1. I am using Excel 2003 > > 2. All

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

2010-05-21 Thread Paul Schreiner
XCEL AND VBA MACROS Sent: Fri, May 21, 2010 11:55:43 AM Subject: Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste Hi Paul - Thanks for the reply.  Let me attempt to answer your questions and hopefully clarify a bit. 1. I am using Excel 2003 2. All of the steps prior to the code I

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

2010-05-21 Thread Erick C
Hi Paul - Thanks for the reply. Let me attempt to answer your questions and hopefully clarify a bit. 1. I am using Excel 2003 2. All of the steps prior to the code I already had were serving only one purpose. I want to write the text file using only rows where the date in column T equals the date

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

2010-05-21 Thread Paul Schreiner
I have a few questions. What version of Excel are you using? You said in step 6, you "cut" the records that AG is null did you really man "cut", as in: removed from sheet1? also, you're writing a file with : a.WriteLine s1 & s2 & s3 & s4 & s5 & s6 but the values have no spaces or delimiters bet