Excel Macro

IN PROGRESS
Bids
39
Avg Bid (USD)
N/A
Project Budget (USD)
$30 - $250

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
-Iterate

Skills required:
Visual Basic
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.