Consolidate from multiple workbooks

Background Info
1. I am running Excel 2007 on Windows XP

2. I have 10+ “feeder files” and one “Rollup” file located in folder.

3. Each feeder file contains two worksheets: “SOTF” and “Directions”

4. The “Rollup” file also contains two worksheets: “CJSOTF” and “Directions”

5. The “SOTF” sheets vary in data length, however all data starts on row 6. “SOTF” sheets all have data in columns A-J (i.e. 10 columns of data).

Requirement: I need to combine all the data from the “SOTF” sheets into an existing “CJSOTF” sheet in the “Rollup” file.

Feeder File -- SOTF Example #1:
A B C D E F G H I J
XX XX XX XX XX XX XX XX XX XX
QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ
MM MM MM MM MM MM MM MM MM MM


Feeder File -- SOTF Example #2
A B C D E F G H I J
PPP PPP PPP PPP PPP PPP PPP PPP PPP PPP
ZZZ ZZZ ZZZ ZZZ ZZZ ZZZ ZZZ ZZZ ZZZ ZZZ
RRR RRR RRR RRR RRR RRR RRR RRR RRR RRR
VVV VVV VVV VVV VVV VVV VVV VVV VVV VVV
UUU UUU UUU UUU UUU UUU UUU UUU UUU UUU
TTT TTT TTT TTT TTT TTT TTT TTT TTT TTT


Desired Result (on “CJSOTF”)
A B C D E F G H I J
XX XX XX XX XX XX XX XX XX XX
QQ QQ QQ QQ QQ QQ QQ QQ QQ QQ
MM MM MM MM MM MM MM MM MM MM
PPP PPP PPP PPP PPP PPP PPP PPP PPP PPP
ZZZ ZZZ ZZZ ZZZ ZZZ ZZZ ZZZ ZZZ ZZZ ZZZ
RRR RRR RRR RRR RRR RRR RRR RRR RRR RRR
VVV VVV VVV VVV VVV VVV VVV VVV VVV VVV
UUU UUU UUU UUU UUU UUU UUU UUU UUU UUU
TTT TTT TTT TTT TTT TTT TTT TTT TTT TTT

Install this macro into your main workbook. The fPath string is set to match the folder where these the main file is, so it should be in the folder with the files to import. We can change that if you want so they are separate...

Please Login or Register  to view this content.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.