linking cells again :-(


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
 
Ad

Advertisements

C

CLR

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
 
P

pegman

OK, that will probably work... I pulled up that annoyying little paper clip
guy that is always tapping on my screen and typed in 'assigning cell number
to element'... no help there...

this is driving me nuts
 
C

CLR

This seems to work fine........

=SUM(B1:D1)+INDIRECT("A"&E1)

Vaya con Dios,
Chuck, CABGx3
 
P

pegman

I've been playing with this a little, I hate to just drop this because I not
a very bright guy and you guys are trying to help me figure this out...
Thanks... I keep getting errors though...

=COUNT(Sold!I16) is one of the formulas, all the formulas need to change the
'16' is the variable
 
Ad

Advertisements

Ad

Advertisements

P

pegman

HEHEHE... I'M A BLOODY GENIUS!!!

I typed in something like =COUNT(INDIRECT("Sold!I"&D1)) and it works
great!!! Guess if I stay at it long enough I can figure anything out!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top