I have a Microsoft Access Database from which i want to import data into an
excel sheet. This i can do but what i want to do is to have formulas to run
totals and other calculations on each field (column). I don't know how many
records i will be importing each time i do this and want to set the
worksheet(s) up to calculate the formulas based on all the records.

So if say i transfer 15 records then i can calculate the total cost of the
data in the field "Expenses", or maybe i will have 25 records, or 40 (the
data is being transfered through a Macro off an Access query)

Basically myquestion boils down to the question... How do i set up Excel to
handel a dynamic number of records in a separate worksheet?

One way would be to have a "freeze-line" about row 10, and have your formulas
ABOVE the freeze-line (like =SUM(A11:A65000)) and your data imported below
the freeze-line

hth
Vaya con Dios,
Chuck, CABGx3



"Engels" wrote:

I have a Microsoft Access Database from which i want to import data into an
excel sheet. This i can do but what i want to do is to have formulas to run
totals and other calculations on each field (column). I don't know how many
records i will be importing each time i do this and want to set the
worksheet(s) up to calculate the formulas based on all the records.

So if say i transfer 15 records then i can calculate the total cost of the
data in the field "Expenses", or maybe i will have 25 records, or 40 (the
data is being transfered through a Macro off an Access query)

Basically myquestion boils down to the question... How do i set up Excel to
handel a dynamic number of records in a separate worksheet?