In Progress

Excel Macro

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


Skills: Visual Basic

See more: master excel, excel 2013, copy paste names in excel, sheet excel visual basic, 2013 excel visual basic, excel 2013 visual, excel 2013 macro, excel macro open workbook, file name excel, excel macro access, visual basic excel 2013, excel macro open file, excel column copy, open workbook open file file, macro open file workbook, macro open excel workbook, open workbook macro, excel 2013 visual basic, master excel sheet, macro open file open workbook, macro open workbook, excel contain, excel files directory, excel master sheet, macro copy files folder excel

About the Employer:
( 2 reviews ) Conroe, United States

Project ID: #4184514