Lapsys
06-26-2014, 12:36 AM
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.
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.