Importing data into existing worksheet
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? |
Importing data into existing 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? |
All times are GMT +1. The time now is 04:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com