+ Reply to Thread
Results 1 to 2 of 2

Macro to copy the value of some cells in excel files in a folder to a master file

  1. #1
    Registered User
    Join Date
    09-30-2013
    Location
    Nigeria
    MS-Off Ver
    Excel 2007
    Posts
    2

    Macro to copy the value of some cells in excel files in a folder to a master file

    Please i need your help.

    I want to be able to copy Cells 'C3' in individual sheet files to Column L starting from 'L5' in the summary file. I also want to be able to copy from Cells 'I15' to 'N5'. The summary file is the master file while the individual sheet files are individualistics and can be as much as 20 files stored in a folder. I have attached the sample files.

    Kindly help

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Macro to copy the value of some cells in excel files in a folder to a master file

    http://www.rondebruin.nl/tips.htm
    If solved remember to mark Thread as solved

+ 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. Macro to copy some cells in some excel files in a folder to a master file
    By phemocheee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2013, 04:40 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. [SOLVED] Copy/paste Range of worksheets of several files in a folder to a master file
    By mrjinx007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2013, 01:02 PM
  4. [SOLVED] Macro to copy file names and data from each file in a folder into master spreadsheet
    By dee1989 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-10-2012, 05:52 AM
  5. Replies: 3
    Last Post: 02-22-2012, 11:40 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