P
pegman
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
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