+ Reply to Thread
Results 1 to 3 of 3

Copy data from one workbook to a specific sheet in another workbook without overriding

  1. #1
    Registered User
    Join Date
    11-29-2017
    Location
    newport
    MS-Off Ver
    MS Office 365
    Posts
    21

    Copy data from one workbook to a specific sheet in another workbook without overriding

    Hello everyone,

    I am sorry to bother everyone but I am stuck. I am trying to add a macro which, when activated, takes data from one workbook to a specific sheet in another. the details of what I am trying to achieve is;

    1. copy data that is contained within cells B3: F3 and down (ideally the macro will miss out the blanks when the data ends) from Workbook1
    2. Paste that data into Sheet1 within Workbook2 into cells A3:E3 down
    3. also when it pastes for the data that was already in there not to be overridden

    The macro I have tried and failed to us is;

    Please Login or Register  to view this content.

    Thanks everyone!!

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    3,730

    Re: Copy data from one workbook to a specific sheet in another workbook without overriding

    Can the blanks be deleted before copying? If not, no problem.
    No 2 and No 3 contradict each other. Forget about them and just call it "to the first empty cell/row in Sheet1, wb2"
    If there is data in Sheet1, wb2, are all the columns the same length?
    By the looks of it, the 2nd workbook is closed and need to be opened.
    Where is the 2nd Workbook saved? Don't need the path but makes things easier (for me anyway)

    In the meantime, how far do you get with this? (Need to delete the empties yet.)
    Please Login or Register  to view this content.
    I don't know if it works if you insert
    Please Login or Register  to view this content.
    before
    Please Login or Register  to view this content.
    Last edited by jolivanes; 11-30-2017 at 08:14 PM. Reason: add info

  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    3,730

    Re: Copy data from one workbook to a specific sheet in another workbook without overriding

    Since we have nothing to work with, this is another stab in the semi darkness. The previous deleting empties did not work. Maybe this one does.
    I don't think that I need to suggest to try it on copies of your workbooks first. With code, gone is gone.
    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. [SOLVED] vba code to copy a specific sheet from a closed workbook to the active workbook
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-01-2017, 03:09 AM
  2. [SOLVED] vba copy specific sheet from closed workbook to active workbook
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2017, 01:33 PM
  3. [SOLVED] copy specific sheet from closed workbook to active workbook
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2017, 10:26 PM
  4. vba copy specific sheet from closed workbook to active workbook
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2017, 02:34 PM
  5. [SOLVED] Copy Each Sheet in Workbook to New Specific Workbook
    By KT99 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 10-13-2014, 02:21 PM
  6. macro to copy data from one workbook to another on specific sheet
    By Chetan Chauhan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-08-2014, 02:01 PM
  7. copy of sheet from specific workbook to active workbook
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2014, 07:31 AM

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