+ Reply to Thread
Results 1 to 3 of 3

Tranfer Rows between Workbooks

  1. #1
    Registered User
    Join Date
    04-29-2017
    Location
    London
    MS-Off Ver
    2016 Professional
    Posts
    50

    Tranfer Rows between Workbooks

    Dear All

    I would normally use PowerQuery to achieve the following but this time I need a solution for Excel 2007 and 2010. Hence I am interested if it can be achieved using VBA (with which I am not familiar).

    I have two Workbooks A & B. Each workbook contains a table on Sheet 1. The tables have the same number of columns in the same sequence however the number of rows may differ, Workbook A may have more rows than Workbook B, and sequence of the rows may differ. The first column in both tables contains a unique alphanumeric value.

    Working from within Workbook A, I need to compare the tables (based on the unique value in column A) and if the table in Workbook B has any missing rows transfer the missing row(s) to the bottom of the table in Workbook B.

    Any advise or guidance would be gratefully received.


    DW

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: Tranfer Rows between Workbooks

    Do you want to compare only the unique values in column A or the entire row? It would be easier to help and test possible solutions if you could attach a copy of your files. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.
    Last edited by Mumps1; 09-01-2020 at 08:53 AM.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Tranfer Rows between Workbooks

    Possibly...
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Tranfer data to another sheet
    By 209dude in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-15-2015, 05:45 PM
  2. Tranfer data to another sheet
    By 209dude in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2015, 07:59 PM
  3. Tranfer new data from one work sheet to another
    By IrinaP in forum Excel General
    Replies: 1
    Last Post: 12-04-2012, 07:06 PM
  4. tranfer data beatween three worksheets
    By ALEZI in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2012, 06:46 AM
  5. from excel to gmail tranfer
    By ohnono in forum Excel General
    Replies: 2
    Last Post: 08-05-2008, 07:07 AM
  6. [SOLVED] tranfer array to range
    By AD108 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2006, 11:49 AM
  7. [SOLVED] Pls Help on from date tranfer amount to month
    By Tiya in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2006, 12:40 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1