S
Scot
I have created a spreadsheet that querries a data base using the SS number
as the key. Due to the size of the spreadsheet (35MB) I prefer to leave the
calculation set on manual. When I enter the SS number in the spreadsheet, I
then press f9 to begin the querry. Once the querry has imported the data I
have to press f9 again, to populate the data from the qeurry throughout the
rest of the spreadsheet. I have a macro that runs a series of calculations
to produce a report. I would like to incorporate the manual calculation
(f9) into the macro. If I simply add f9 twice in a row, it seems to happen
so quickly that the second f9 happens before the querry has completed (it
takes 5-10 seconds for the querry to be completed). Any ideas on how to
have both calculations take affect or some other way to do this?
Scot
as the key. Due to the size of the spreadsheet (35MB) I prefer to leave the
calculation set on manual. When I enter the SS number in the spreadsheet, I
then press f9 to begin the querry. Once the querry has imported the data I
have to press f9 again, to populate the data from the qeurry throughout the
rest of the spreadsheet. I have a macro that runs a series of calculations
to produce a report. I would like to incorporate the manual calculation
(f9) into the macro. If I simply add f9 twice in a row, it seems to happen
so quickly that the second f9 happens before the querry has completed (it
takes 5-10 seconds for the querry to be completed). Any ideas on how to
have both calculations take affect or some other way to do this?
Scot