"Brett Patterson"

That's great, you were right.

You're welcome !

But what I'm trying to do is automate it so
that I don't have to copy any of the forumla or cell for each line. So is
there a way to automate the display so that it will always show "$0.00"
and
then when values change, the amount changes. But I don't want to have to
copy the cell manually as the data will be spread over numerous pages and
manual copying would take too long.

sorry, I'm not sure on this new Q of yours
do hang around awhile for insights from others
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----