Gather info from mulitple files and aggregate into one

jtriggs1941

New Member
Joined
Sep 28, 2006
Messages
2
I have a form that reps fill out and place in a server folder. I have the form set up so that their responses link from the form cells into cells M2:BB2. Is there any way I can automatically get the data from each of these files to feed into one file? This way I can aggregate it into reports for the boss. Please advise.

Thanks,
Terri
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

ravishankar

Well-known Member
Joined
Feb 23, 2006
Messages
3,566
A macro may help you
List all excel files to be collated in column a (terry.xls)

paste the following code in the window got from Alt F8
keep all excel files open.

Sub from()
For a = 2 To 3 ( or as many excel files to be added)
b = Cells(a, 1)
For c = 13 To 42
Cells(a, c + 1) = Workbooks(b).Worksheets("sheet1").Cells(1, c)
Next c
Next a
End Sub

run the macro
good luck

Ravi
 

Forum statistics

Threads
1,141,914
Messages
5,709,313
Members
421,627
Latest member
bennhrios9

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top