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?