Results 1 to 8 of 8

VBA Code to read Files

Threaded View

  1. #1
    Registered User
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    4

    Unhappy VBA Code to read Files

    Hi,

    I have a pretty time consuming project due tomorrow and I'm looking for some guidance on the fastest way to pull this off. I am sending an excel file containing four tabs (Block 1, Block 2, Block 3, Block 4) to 20 folks. Once they fill in scores, each of them will email me their files back. I have created a "Master" file for myself and the plan is to copy/paste the data 80 times (4 tabs X 20 attendees). I know there is an easier way to do this, but I don't know much VBA code. Is there a way I can dump all the files in a folder and have excel read and populate the data on my "Master File"? All the data is the exact same on all 20 spreadsheets with the exception of the scores and names of course. I have attached the template going to the attendees and what my "Master" file should look like. Any help is greatly appreciated.

    Niki
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Read Only Files
    By Mel B in forum Excel General
    Replies: 1
    Last Post: 06-25-2013, 09:48 AM
  2. VB Code to dynamically read csv files and create charts within Excel.
    By rbahadur in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-27-2012, 12:55 AM
  3. Macro code to read multiple text files
    By sathik in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2012, 03:42 AM
  4. Replies: 6
    Last Post: 04-02-2009, 02:34 PM
  5. VB Code to 'read' .txt files and display info in Excel
    By Petitboeuf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2005, 12:00 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