If you want to change a single element simultaneously in multiple formulas,
just assign the same cell number to that element in each of those formulas,
then vary the value of that cell...........

Vaya con Dios,
Chuck, CABGx3



"pegman" wrote:

Suleman, thanks for trying but stil no go... maybe what you responded will
work and I just misunderstand what to do.

I have a database in one worksheet that controls customer info, inventory
and tracks sales by an invoice number. I am trying to create an invoice that
is autmatically populated by the information from that worksheet.

On the invoice (new worksheet) I would like to change a single value in
multiple formulas automatically... Basically, I would just like to change the
row number (in multiple cells) on the new worksheet...

maybe I'm going about this all the wrong way
--
I didn''''t go bald because of genetics, I''''m pulling them out one at a
time!