+ Reply to Thread
Results 1 to 5 of 5

vba, excel ,copy ,rows

  1. 06-09-2020, 03:09 AM #1
    carrollm
    carrollm is offline
    Registered User
    Join Date
    09-10-2012
    Location
    texas usa
    MS-Off Ver
    Excel 2010
    Posts
    70

    vba, excel ,copy ,rows

    purpose of code is to copy the rows in workbook "testuseddata"
    to workbook "testused.xlsx" start in cell e1 if used or consignment
    occurs in column c of workbook "testuseddata"

    I cant get the code correct to paste the rows

    Thanks for any help
    Carroll
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-09-2020, 04:31 AM #2
    MRUTOR
    MRUTOR is offline
    Registered User
    Join Date
    05-14-2020
    Location
    Mauritius
    MS-Off Ver
    Office 365
    Posts
    97

    Re: vba, excel ,copy ,rows

    Hi,

    here a working code. Tested on your files:
    Please Login or Register  to view this content.
    Greetings

    Tor

    Reply With QuoteRegister To Reply
  3. 06-09-2020, 04:38 AM #3
    karmapala
    karmapala is offline
    Valued Forum Contributor
    Join Date
    11-04-2018
    Location
    Denpasar
    MS-Off Ver
    Excel 2010
    Posts
    777

    Re: vba, excel ,copy ,rows

    Maybe something like this ?
    Please remove the Option Explicit first.

    Please Login or Register  to view this content.
    That's if I'm not mistaken to get what you mean .
    Last edited by karmapala; 06-09-2020 at 04:54 AM.
    Reply With QuoteRegister To Reply
  4. 06-10-2020, 10:32 AM #4
    carrollm
    carrollm is offline
    Registered User
    Join Date
    09-10-2012
    Location
    texas usa
    MS-Off Ver
    Excel 2010
    Posts
    70

    Re: vba, excel ,copy ,rows

    Thank You for the code Works great.
    Reply With QuoteRegister To Reply
  5. 06-10-2020, 10:39 AM #5
    carrollm
    carrollm is offline
    Registered User
    Join Date
    09-10-2012
    Location
    texas usa
    MS-Off Ver
    Excel 2010
    Posts
    70

    Re: vba, excel ,copy ,rows

    Thanks Mrutor
    Code works good - Like the use of xltoleft.
    Last edited by carrollm; 06-10-2020 at 10:46 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy rows from Outlook to Excel
    By SHIR0206 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2019, 05:58 AM
  2. Excel 2007 Macro cut/copy/paste alternate cell rows to the next column & delete empty rows
    By dvkarras in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2019, 10:54 AM
  3. Excel Sheet which will copy specific amount of rows to different Excel Workbook
    By Fredbugatti in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2018, 04:42 PM
  4. How to perform 'insert rows' instead of 'copy rows' using .copyrecordset (excel vba)
    By praful k in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2013, 06:06 AM
  5. Bypass Excel Rows limit and continue to copy data files to Excel
    By Mach7 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-16-2012, 07:40 AM
  6. Cannot copy sheet from Excel 2007 to Excel 2010 - Destination Contains Fewer Rows
    By m3atball in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-02-2011, 01:33 AM
  7. Excel - copy subtotal rows only
    By Russ in forum Excel General
    Replies: 1
    Last Post: 09-14-2005, 06:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1