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