Results 1 to 10 of 15

Thread: Meger multiple file but header not same

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 10-24-2012, 10:37 AM #1
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi rocky,

    Welcome to ExcelFox!!

    Please explain what kind of error you got and at which line ?
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
  2. 10-24-2012, 07:10 PM #2
    rocky
    rocky is offline
    Junior Member
    Join Date
    Oct 2012
    Posts
    8
    Rep Power
    0

    Meger multiple file but header not same

    Hi

    The error I getting is

    Run-time error '13'
    Type mismatch

    When I click on debug the following line getting an error.

    UniqueHeaders Application.Index(d, 1, 0)

    However I have identify that header in some of excel sheet is not same but I need to consolidated the data from all workbook. Please help me.


    Quote Originally Posted by Admin View Post
    Hi rocky,

    Welcome to ExcelFox!!

    Please explain what kind of error you got and at which line ?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Consolidate multiple workbooks from a folder into one master file VBA
    By mynorthraleightutor in forum Excel Help
    Replies: 1
    Last Post: 06-07-2013, 10:32 AM
  2. Loop Through And Delete Multiple File Types In A Folder
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 03-30-2013, 04:47 PM
  3. Consolidate Multiple work sheets and save into a specified file
    By jobledo in forum Excel Help
    Replies: 1
    Last Post: 03-07-2013, 11:42 AM
  4. Consolidate multiple workbooks from a folder into one master file VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 4
    Last Post: 02-26-2013, 09:00 PM
  5. Sort Data When a Header Is Clicked
    By Rasm in forum Excel Help
    Replies: 9
    Last Post: 08-01-2012, 06:46 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
  •  

Forum Rules