+ Reply to Thread
Results 1 to 4 of 4

Need help for consolidating cell values from multiple files in folder into master files

Hybrid View

  1. #1
    Registered User
    Join Date
    08-04-2015
    Location
    newyork
    MS-Off Ver
    2010
    Posts
    16

    Need help for consolidating cell values from multiple files in folder into master files

    I m trying to loop through all the excel files in the folder and copying data from two specific cells of each excel file and consolidate that in Summary sheet.

    for.eg.
    Column A Column B
    Sheet A : Field A Field B
    Sheet B : Field A Field B


    Summary Sheet
    Column A Column B Column C
    Sheet A Field A Field B
    Sheet B Field A Field B

    Currently I m stuck with below code and I will appreciate any help.

    Option Explicit
    Sub Test()

    Dim wbk As Workbook
    Dim filename As String
    Dim Path As String
    Dim myobj As Object

    Path = "H:\2013\consolidate\"
    filename = Dir(Path & "*.xlsx")
    '--------------------------------------------
    'OPEN EXCEL FILES
    Do While Len(filename) > 0 'IF NEXT FILE EXISTS THEN

    Set wbk = Workbooks.Open(Path & filename)

    ????

    wbk.Close True


    filename = Dir()

    Loop
    End Sub

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Need help for consolidating cell values from multiple files in folder into master file

    Can you upload sample of your files to be more clearer?
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: Need help for consolidating cell values from multiple files in folder into master file

    Here's a free Excel add-in that may do what you want.
    RDBMerge, Excel Merge Add-in
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  4. #4
    Registered User
    Join Date
    08-04-2015
    Location
    newyork
    MS-Off Ver
    2010
    Posts
    16

    Re: Need help for consolidating cell values from multiple files in folder into master file

    Thank you it worked

+ 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. Replies: 2
    Last Post: 02-08-2014, 04:45 AM
  2. [SOLVED] How to Copy cell value of all files which inside of folder and append to Master file
    By snsuvarna in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-06-2013, 03:38 PM
  3. Replies: 2
    Last Post: 03-23-2013, 04:17 AM
  4. consolidating data from many files in a folder
    By ryansittler in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2013, 06:32 PM
  5. Copying data from multiple files in a folder to a master file
    By kjshep in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2012, 12:31 PM
  6. Replies: 9
    Last Post: 04-18-2012, 08:50 AM
  7. Replies: 3
    Last Post: 02-22-2012, 11:40 AM
  8. Replies: 10
    Last Post: 04-05-2007, 12:54 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