Re: $$Excel-Macros$$ Copy & Paste next blank row
God bless you! That got it! Thanks so much!!!
On May 6, 1:53 am, Deepak Pal Singh wrote:
> Hi Bob,
>
> I'm sorry bro, I didn't understand your problem completely...
> There is a minor problem with the code that you"ve written.. If you copy the
> complete column then you can paste it only from row no 1 of the worksheet.
>
> So instead of copying the complete column you just need to copy those rows
> till you data exist..
>
> Like you're copying Data from Sheet1 and want to paste it on sheet "Customer
> Record" than you can write the following code...
>
> Sub Copy_Data()
> Dim LastRow As Long
>
> LastRow=Sheet1.Range("A6").End(xlUp).Row
> Sheet1.Range("A1:E" & LastRow).Copy
>
> Sheets("Customer Record").Range("A6").End(xlUp).Offset(1,0).PasteSpecial
> Paste:=xlPasteAll
> Application.CutCopyMode=False
>
> End Sub
>
> Thanks
> Deepak
>
> On Fri, May 6, 2011 at 10:56 AM, NOORAIN ANSARI
> wrote:
>
>
>
>
>
> > -- Forwarded message --
> > From: Bob
> > Date: Fri, May 6, 2011 at 5:22 AM
> > Subject: $$Excel-Macros$$ Copy & Paste next blank row
> > To: MS EXCEL AND VBA MACROS
>
> > I'm sorry , Still having trouble with copy on next available blank
> > row. If I record a macro it's:
> > Columns("A:E").Select
> > Selection.Copy
> > Sheets("Customer Record").*Range("a65356").End(xlUp).Offset(1,
> > 0).Select
> > *
> > ActiveSheet.Paste
> > I want to keep what I have already copied. How do I make it go to the
> > next available blank row.
> > Thanks in Advance.
>
> > --
>
> > ------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
> > --
> > Thanks & regards,
> > Noorain Ansari
>
> > --
>
> > ------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel- Hide quoted text -
>
> - Show quoted text -
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Copy & Paste next blank row
send email to excel-macros@googlegroups.com
and add the attachment
On Fri, May 6, 2011 at 4:24 PM, Bob wrote:
> Were is it located to attach file? Sorry I don't see it. Thanks
>
> On May 6, 1:25 am, ashish koul wrote:
> > can you share the sample file
> >
> >
> >
> >
> >
> > On Fri, May 6, 2011 at 5:22 AM, Bob wrote:
> > > I'm sorry , Still having trouble with copy on next available blank
> > > row. If I record a macro it's:
> > > Columns("A:E").Select
> > >Selection.Copy
> > >Sheets("Customer Record").Select
> > >ActiveSheet.Paste
> > > I want to keep what I have already copied. How do I make it go to the
> > > next available blank row.
> > > Thanks in Advance.
> >
> > > --
> >
> > >
> ------
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > Like our page on facebook , Just follow below link
> > >http://www.facebook.com/discussexcel
> >
> > --
> > *Regards*
> > * *
> > *Ashish Koul*
> > *akoul*.*blogspot*.com
> >
> > P Before printing, think about the environment.- Hide quoted text -
> >
> > - Show quoted text -
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com
P Before printing, think about the environment.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Copy & Paste next blank row
Hi Bob,
I'm sorry bro, I didn't understand your problem completely...
There is a minor problem with the code that you"ve written.. If you copy the
complete column then you can paste it only from row no 1 of the worksheet.
So instead of copying the complete column you just need to copy those rows
till you data exist..
Like you're copying Data from Sheet1 and want to paste it on sheet "Customer
Record" than you can write the following code...
Sub Copy_Data()
Dim LastRow As Long
LastRow=Sheet1.Range("A6").End(xlUp).Row
Sheet1.Range("A1:E" & LastRow).Copy
Sheets("Customer Record").Range("A6").End(xlUp).Offset(1,0).PasteSpecial
Paste:=xlPasteAll
Application.CutCopyMode=False
End Sub
Thanks
Deepak
On Fri, May 6, 2011 at 10:56 AM, NOORAIN ANSARI wrote:
>
>
> -- Forwarded message ------
> From: Bob
> Date: Fri, May 6, 2011 at 5:22 AM
> Subject: $$Excel-Macros$$ Copy & Paste next blank row
> To: MS EXCEL AND VBA MACROS
>
>
> I'm sorry , Still having trouble with copy on next available blank
> row. If I record a macro it's:
> Columns("A:E").Select
>Selection.Copy
>Sheets("Customer Record").*Range("a65356").End(xlUp).Offset(1,
> 0).Select
> *
>ActiveSheet.Paste
> I want to keep what I have already copied. How do I make it go to the
> next available blank row.
> Thanks in Advance.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Copy & Paste next blank row
Were is it located to attach file? Sorry I don't see it. Thanks
On May 6, 1:25 am, ashish koul wrote:
> can you share the sample file
>
>
>
>
>
> On Fri, May 6, 2011 at 5:22 AM, Bob wrote:
> > I'm sorry , Still having trouble with copy on next available blank
> > row. If I record a macro it's:
> > Columns("A:E").Select
> > Selection.Copy
> > Sheets("Customer Record").Select
> > ActiveSheet.Paste
> > I want to keep what I have already copied. How do I make it go to the
> > next available blank row.
> > Thanks in Advance.
>
> > --
>
> > ------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com
>
> P Before printing, think about the environment.- Hide quoted text -
>
> - Show quoted text -
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Copy & Paste next blank row
Just add the following line to your code..
Sheets("Customer
Record").Range("ABZ1").End(xlToLeft).Offset(0,1).PasteSpecial
Paste:=xlPasteValues
Regards
Deepak
On Fri, May 6, 2011 at 5:22 AM, Bob wrote:
> I'm sorry , Still having trouble with copy on next available blank
> row. If I record a macro it's:
> Columns("A:E").Select
>Selection.Copy
>Sheets("Customer Record").Select
>ActiveSheet.Paste
> I want to keep what I have already copied. How do I make it go to the
> next available blank row.
> Thanks in Advance.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Fwd: $$Excel-Macros$$ Copy & Paste next blank row
-- Forwarded message --
From: Bob
Date: Fri, May 6, 2011 at 5:22 AM
Subject: $$Excel-Macros$$ Copy & Paste next blank row
To: MS EXCEL AND VBA MACROS
I'm sorry , Still having trouble with copy on next available blank
row. If I record a macro it's:
Columns("A:E").Select
Selection.Copy
Sheets("Customer Record").*Range("a65356").End(xlUp).Offset(1, 0).Select
* ActiveSheet.Paste
I want to keep what I have already copied. How do I make it go to the
next available blank row.
Thanks in Advance.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Thanks & regards,
Noorain Ansari
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Copy & Paste next blank row
can you share the sample file
On Fri, May 6, 2011 at 5:22 AM, Bob wrote:
> I'm sorry , Still having trouble with copy on next available blank
> row. If I record a macro it's:
> Columns("A:E").Select
>Selection.Copy
>Sheets("Customer Record").Select
>ActiveSheet.Paste
> I want to keep what I have already copied. How do I make it go to the
> next available blank row.
> Thanks in Advance.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com
P Before printing, think about the environment.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
$$Excel-Macros$$ Copy & Paste next blank row
I'm sorry , Still having trouble with copy on next available blank
row. If I record a macro it's:
Columns("A:E").Select
Selection.Copy
Sheets("Customer Record").Select
ActiveSheet.Paste
I want to keep what I have already copied. How do I make it go to the
next available blank row.
Thanks in Advance.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
