i have a summary workbook that gets data from 12 users workbooks, the
summary workbook has 12 sheets (one for each month) all in the same folder
on a network drive. right now i just have formulas as links to all of the
workbooks. there are 12 formulas like this on each of the 12 sheets in the
summary workbook
example

='N:\My Documents\Excel\RECCU\FSA\[April.xls]Branch'!C43+'N:\My
Documents\Excel\RECCU\FSA\[Celia.xls]Branch'!C43+'N:\My
Documents\Excel\RECCU\FSA\[Darlene.xls]Branch'!C43+'N:\My
Documents\Excel\RECCU\FSA\[Dawn.xls]Branch'!C43+'N:\My
Documents\Excel\RECCU\FSA\[Kathy.xls]Branch'!C43+'N:\My
Documents\Excel\RECCU\FSA\[Kim.xls]Branch'!C43+'N:\My
Documents\Excel\RECCU\FSA\[Kristin_T.xls]Branch'!C43+'N:\My
Documents\Excel\RECCU\FSA\[Maria.xls]Branch'!C43+'N:\My
Documents\Excel\RECCU\FSA\[Nicci.xls]Branch'!C43+'N:\My
Documents\Excel\RECCU\FSA\[Nicole.xls]Branch'!C43+'N:\My
Documents\Excel\RECCU\FSA\[Roberta.xls]Branch'!C43+'N:\My
Documents\Excel\RECCU\FSA\[Sue_D.xls]Branch'!C43

someone said i may be faster to use code. well, i have all of the loops and
everything works fine. i created the same formula using vb that i have above

vb formula:

ActiveCell.Formula = "=[April.xls]Branch!" & MyRange & " +
[Celia.xls]Branch!" & MyRange & "" & _
" +[Darlene.xls]Branch!" & MyRange & " +[Dawn.xls]Branch!" & MyRange & ""
& _
" + [Kathy.xls]Branch!" & MyRange & " + [Kim.xls]Branch!" & MyRange & " +
[Kristin_T.xls]Branch!" & MyRange & "" & _
" + [Maria.xls]Branch!" & MyRange & " +[Nicci.xls]Branch!" & MyRange & ""
& _
" + [Nicole.xls]Branch!" & MyRange & " +[Roberta.xls]Branch!" & MyRange
& " + [Sue_D.xls]Branch!" & MyRange & ""

it has to do this routine 12 times to create all the formulas for each of
the 12 sheets in the summary workbook, depending on the month they choose.

is there a faster way to get the data out of the 12 workbooks than creating
formulas like i did?
--


Gary