Need a Macro to grap individual data cells and check box data,Multiple files into single

Having trouble with this. Need a macro that pulls unigue cell data from all of the excel files in one directory and combines them into rows of data on a single excel form so that reports can be generated with the data. One of the wringles is that two of the cell data points I need are check boxes.

I need to pull in the following cell feilds in this order on the new file.

Source - New File
F2-A
F3-B
F9-C
F4-D
C9-E
C11-F
F11-G
I11-H
A14-I
A21-J
A23-K
CHECK BOX 12-L
CHECK BOX 11-M

Thanks

Eric

Tigeravatar,

Are the checkboxes ActiveX controls or Form controls? Forms
Do you only need to know if the checkboxes are checked or not? If so, what do you want to represent checked/unchecked? (like TRUE = checked, FALSE = unchecked, or something else?) False or checked works
Will the new file have headers? If so, what are the headers?
F2-A-Date
F3-B-Tracking Number
F9-C-New P.O.
F4-D-Original P.O.
C9-E-Customer
C11-F-Part Number
F11-G-Serial Number
I11-H-Lot Number
A14-I-Reason for Return
A21-J-Comments
A23-K-Findings
Check Box 12-L-Agree
Check Box 11-M-Disagree

Are the excel files always in the same directory? Does it have subfolders? No all in same directory

Eric

Tigeravatar,

Not sure what is wrong but with my file it just keeps looping without letting me Debug. Here are two examples of the files in the folder.

Eric

Tigeravatar,

That worked great Thank you, Now I just need to make a report function to output based on some variables.

Eric