+ Reply to Thread
Results 1 to 5 of 5

merge the specific cells from numbers of files...

  1. #1
    Registered User
    Join Date
    12-03-2013
    Location
    Nepal
    MS-Off Ver
    Excel 2003
    Posts
    3

    merge the specific cells from numbers of files...

    There are around 200 excel files in a folder eg D:\test and all the excel file have a sheet and every sheet are of same format only different is the content of the excel file. I need to create a summary excel which contain all the required info from the 200 excel file. i am confused how to solve this?

    for eg
    the header1 is in A3 and its value in A4
    header 2 in A5 and its value in A6
    header3 in B6 and its value in D8 and so on

    i need to copy the header and value in new excel sheet.
    how to solve this?

    Please help me to solve this..

  2. #2
    Forum Contributor
    Join Date
    03-28-2013
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    226

    Re: merge the specific cells from numbers of files...

    we can do this but, can you post a example workbook with sample data.

    venkat
    Give Feedback and Click(*)

  3. #3
    Registered User
    Join Date
    12-03-2013
    Location
    Nepal
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: merge the specific cells from numbers of files...

    thank you venkatpvc for your reply here i ve attached the sample of my excel file,

    regards
    cjan_05
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    03-28-2013
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    226

    Re: merge the specific cells from numbers of files...

    I am not sure this is what you looking for 100% but i put together some code please check and tell me, if this is not what you looking for.
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    12-03-2013
    Location
    Nepal
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: merge the specific cells from numbers of files...

    Thank you venkatpvc for your code, this is somewhat similar to my requirement. i will change the code to get the result as per my requirement. once again thank you for your time and reply..

    regards
    cjan_05

+ 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. [SOLVED] Want to merge specific cells from 1000+ files into one master file
    By dunnybocter in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-15-2013, 02:52 AM
  2. [SOLVED] How to merge a numbers from 3 cells, eliminate repetitive numbers, and sort such numbers?
    By david gonzalez in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-22-2012, 11:59 AM
  3. [SOLVED] Merge Cells When Other Merged Cells Receive Specific Data
    By swordswinger710 in forum Excel Programming / VBA / Macros
    Replies: 39
    Last Post: 04-03-2012, 10:34 AM
  4. merge specific cell from multiple files into 1 file
    By pow828 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-18-2011, 12:35 PM
  5. Merge specific text of 2 cells
    By sandstone in forum Excel General
    Replies: 4
    Last Post: 03-31-2009, 05:04 PM

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