Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
performance question
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Performance Ratings VBA help | Excel Discussion (Misc queries) | |||
Performance | Excel Discussion (Misc queries) | |||
Performance IF(IF or IF(AND | Excel Worksheet Functions | |||
Spreadsheet Performance | Excel Programming | |||
Bad performance | Excel Programming |