Good afternoon --

I built a workbook used to calculate medical fees and productivity. It's
based on several reference lookups, and lots of internal calculations. For
each item, there are three calculations, each of which consists of a formula
60-70 keystrokes long. When the user does this work, (s)he may do it for
100-200 items at a time. Right now, it can take 1-2 minutes to calculate the
entire workbook so I leave calculation set to manual.

My question -- I can either have all the equations located inside the cells,
or create a little VB code to copy and paste them into cells on rows where
they'll be used. That is, if cell A15 has the "part number" to be looked up,
it would paste the lookup and calculation formulas into the appropriate cells
on that row, and then do summary calculations when all done.

Does anyone know which would be faster?

Thanks in advance,