Results 1 to 22 of 22

Copy specific columns from multiple files in folder and combine those columns in workbook

Threaded View

JaffarAhamed Copy specific columns from... 09-10-2023, 11:59 AM
JaffarAhamed Re: Copy specific columns... 09-10-2023, 12:02 PM
alansidman Re: Copy specific columns... 09-10-2023, 12:02 PM
JaffarAhamed Re: Copy specific columns... 09-10-2023, 12:08 PM
6StringJazzer Re: Copy specific columns... 09-10-2023, 10:23 PM
JaffarAhamed Re: Copy specific columns... 09-11-2023, 12:22 AM
JaffarAhamed Re: Copy specific columns... 09-11-2023, 01:24 AM
alansidman Re: Copy specific columns... 09-10-2023, 01:05 PM
jindon Re: Copy specific columns... 09-11-2023, 06:01 AM
JaffarAhamed Re: Copy specific columns... 09-11-2023, 06:41 AM
jindon Re: Copy specific columns... 09-13-2023, 02:19 AM
jindon Re: Copy specific columns... 09-11-2023, 06:47 AM
JaffarAhamed Re: Copy specific columns... 09-11-2023, 07:24 AM
JaffarAhamed Re: Copy specific columns... 09-11-2023, 07:58 AM
jindon Re: Copy specific columns... 09-11-2023, 07:29 AM
jindon Re: Copy specific columns... 09-11-2023, 08:04 AM
jindon Re: Copy specific columns... 09-12-2023, 04:39 AM
JaffarAhamed Re: Copy specific columns... 09-13-2023, 02:11 AM
JaffarAhamed Re: Copy specific columns... 09-13-2023, 03:13 AM
jindon Re: Copy specific columns... 09-13-2023, 04:11 AM
  1. #19
    Registered User
    Join Date
    11-14-2022
    Location
    chennai
    MS-Off Ver
    2016
    Posts
    30

    Re: Copy specific columns from multiple files in folder and combine those columns in workb

    1. The sheet name for all workbook is "owssvr"
    2. i have changed the columns in code based on my requirement, and ensure the columns are matching both in code and in all the files. I have done a check for one column by giving extra space to know whether it copy or not. But it is not copy all other columns because of one column error. I thought the code would pick other columns without the wrong column.
    Last edited by JaffarAhamed; 09-13-2023 at 03:15 AM. Reason: Grammer

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Combine multiple sheets on basis of columns & copy to another workbook at specified sheet
    By sanjuss2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-21-2021, 10:13 AM
  2. [SOLVED] Copy specific columns from all excel files saved in selected folder
    By KKR1975 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-03-2020, 11:03 PM
  3. loop through files find columns and copy/paste them as columns in master workbook
    By Michal1111 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2018, 10:40 PM
  4. [SOLVED] Copy specific columns from multiple workbooks to new workbook
    By nwix in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2017, 10:48 AM
  5. [SOLVED] VBA to Copy the same Columns from multiple files in one folder
    By mcanant in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-16-2014, 03:15 AM
  6. Macro to combine multiple columns keeping few columns specific
    By lramesh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2013, 12:44 PM
  7. Opening all .csv files in a folder and deleting specific columns
    By jamesmac91 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2012, 11:20 AM

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