-
Find and extract information from multiple excel files
Hi all
I know I am supposed to provide code, but I am very new to VBA and thus have no idea what I am doing, but need to use it to get information from a bunch of excel files. Basically, what I need to do is:
1. Open all excel files within a certain folder
2. While each of the files are open, I need to search for a certain row (lets say the row containing the word "Platinum" - note that there is only one of these rows in each spreadsheet)
3. When that row is found, I need to extract information from it (lets say the first 3 columns and the 6th column - so A, B, C and F). This information should all be merged into a single excel spreadsheet.
Thank you very much, all help is much appreciated.
-
Figured it out nevermind!
Thanks anyway.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules