I'm new to macros and have a folder of about 1,000 files. It's basically a form in Excel and I'm looking to extract specific cells from every file and place them in another file acting as a master list. For example, each file has the same sheet name and I want Customer Name (B2), Date (G2), Salesperson (B6), Perimeter (C9), etc. to be in rows. I included a screen shot of both files.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Extract specific cells from multiple files in folder
- Thread starter mittmo
- Start date
Similar threads
- Question
- Solved
