Dave, I have no good idea other than to try to come up with a formula that
does not have to be overwritten every time you enter a new data record. By
this Excel would not spend time on re-doing all existing cells' formulas.
But it will still spend time on re-calculating the results. In this case of
course you wouldn't have to insert new lines but fill content into existing
cells only. That might speed up the process.

I have experience with huge data table being processed over hours and hours
by a macro just because the macro inserted lines into the table. As soon as
I could eliminate the insertion step the speed icreased significantly.

Gabor

"AussieDave" az alábbiakat írta a következo
hírüzenetben: ...
Thanks for your time Gabor. I'm familiar with the techniques you
described and already use them. However, my current problem is
automatically adding hundreds of records from a CSV file to the bottom
of my table, taking up formats and formulae from the preceding lines.
I also have other formulae which SUMIF using the first to last line of
the table and the last line needs to dynamically increase as I add
lines. I already use the solution you suggested but it is VERY slow
when adding hundreds of records.
Again, thanks for your time - Dave