+ Reply to Thread
Results 1 to 7 of 7

Extract data from multiple workbooks to master

  1. #1
    Forum Contributor unley's Avatar
    Join Date
    11-27-2008
    Location
    South Australia
    MS-Off Ver
    MS Office 2007
    Posts
    253

    Extract data from multiple workbooks to master

    I'd like to thank JBeaucaire for the codes he created that I found in this forum but this codes copy the whole data on a sheet

    Please Login or Register  to view this content.
    I'm try to find a way to copy range A2:B17 instead of copy the whole data on a sheet.
    I tried to change this code to range A2:B17
    Please Login or Register  to view this content.
    but with no luck
    Last edited by unley; 09-23-2010 at 11:53 PM.
    I'm using MS Office 2013

  2. #2
    Forum Contributor pr4t3ek's Avatar
    Join Date
    10-13-2008
    Location
    Melbourne, Australia
    MS-Off Ver
    2003 & 2007, 2010
    Posts
    483

    Re: Extract data from multiple workbooks to master

    try this. It may not work, I cannot test it...

    Please Login or Register  to view this content.
    --
    Regards
    PD

    ----- Don't Forget -----

    1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks

    2. Thank those who have helped you by Clicking the scales above each post.

    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

  3. #3
    Forum Contributor unley's Avatar
    Join Date
    11-27-2008
    Location
    South Australia
    MS-Off Ver
    MS Office 2007
    Posts
    253

    Re: Extract data from multiple workbooks to master

    Thank you pr4t3ek for replying

    Unfortunetley there's an error on this code on 'Next row

    Please Login or Register  to view this content.
    It has successfully pasted from the first workbook but then there's a runtime error on the above code before it'll be able to do something with the second workbook (there's only 2 workbook to copy from)
    Last edited by unley; 09-23-2010 at 08:58 PM.

  4. #4
    Forum Contributor pr4t3ek's Avatar
    Join Date
    10-13-2008
    Location
    Melbourne, Australia
    MS-Off Ver
    2003 & 2007, 2010
    Posts
    483

    Re: Extract data from multiple workbooks to master

    just comment that section and see what happens:

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor unley's Avatar
    Join Date
    11-27-2008
    Location
    South Australia
    MS-Off Ver
    MS Office 2007
    Posts
    253

    Re: Extract data from multiple workbooks to master

    Your last code did'nt work but I've found a way round to it.

    Instead of comment both section
    Please Login or Register  to view this content.
    I took the comment off the first section and works fine
    Please Login or Register  to view this content.
    So thank you very much for your time pr4t3ek

  6. #6
    Forum Contributor pr4t3ek's Avatar
    Join Date
    10-13-2008
    Location
    Melbourne, Australia
    MS-Off Ver
    2003 & 2007, 2010
    Posts
    483

    Re: Extract data from multiple workbooks to master

    no probs!

    i didn't think it would have worked... o well, top work! cheers!

  7. #7
    Registered User
    Join Date
    09-24-2010
    Location
    mundra
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Extract data from multiple workbooks to master

    =IF(VLOOKUP(B20,C13:C19,1,FALSE),"Duplicate","OK")

    i get #NA instead of "OK" when "Duplicate" is not applicable

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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