+ Reply to Thread
Results 1 to 4 of 4

Copying specific columns from other workbooks

  1. #1
    Registered User
    Join Date
    07-21-2017
    Location
    NY
    MS-Off Ver
    16.0
    Posts
    25

    Copying specific columns from other workbooks

    Hi All,

    I am having difficulties copying specific columns from different workbooks in Excel into a new workbook.

    Do you have any ideas as to how I'd solve this using VBA, i.e. copying over only Columns A, C, D from multiple places?

    Thanks for any help typing out the code!

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

    Re: Copying specific columns from other workbooks

    Re: "Thanks for any help typing out the code!"
    Code for what?

  3. #3
    Registered User
    Join Date
    07-21-2017
    Location
    NY
    MS-Off Ver
    16.0
    Posts
    25

    Re: Copying specific columns from other workbooks

    To pull certain columns (or a range) from different workbooks in Excel into a new workbook.

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

    Re: Copying specific columns from other workbooks

    Come on now. You certainly must know that you cannot tell a computer: "Get me certain columns (or a range) from a different workbook." "It is in different places!"
    The computer needs to know which columns, from which workbooks, from which sheets, whole column or part column (you mentioned range) where are these workbooks located, which drive (C, E, D or whatever drive), which folders, are they password protected, if so what is the password and on and on.
    Don't forget, you know what you want to accomplish, we don't unless you specifically explain.

+ 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. Copying and consolidating a specific sheet from different workbooks
    By mutzie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2019, 09:22 PM
  2. [SOLVED] Copying certain columns to their own new workbooks on a loop
    By bigjdawg43 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2018, 03:07 PM
  3. Copying columns across workbooks
    By gsuperti in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-19-2014, 10:55 AM
  4. Copying specific data ranges from multiple (closed or in use by others) workbooks
    By TheRetroChief in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2014, 10:39 AM
  5. Copying columns from two different workbooks into one workbook
    By bittersweets in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2013, 05:37 AM
  6. Replies: 1
    Last Post: 08-07-2012, 07:47 PM
  7. Searching and copying specific rows from different workbooks
    By lovi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-23-2011, 09:46 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