Excel Macro

This project was awarded to danielgpratidya for $30 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
Project Description

I have a folder/directory of excel files that each contain a single value that I need to copy and paste into a master workbook. I would also like to have all the file names, of each excel file in the directory copied, and pasted into the master workbook. I believe the below steps are necessary:
-Access a directory
-Open each file in the directory
-Copy the file name, from directory file, and paste into the master workbook->Sheet1->into Column A
-Copy the value located in Sheet1->I15, from directory file
-Pasted Copied value into master workbook->sheet 1->Column B
*make sure the name of the excel file matches the corresponding value
-Close the file

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online