linking problem REALLY NEED SOMEONE TO HELP ME!!

[Nat :\)]

I am trying to link information from our main office copy

to our invoice copy so that when you enter the Co.
information, etc that it transfers over. I have been
successfull at all the sheets EXCEPT the invoice sheet by
using ='OFFICE COPY'!B88 (example) but for the Invoice
sheet gives a value of "0" instead of the information
requested. PLEASE HELP!!!

Muchos Gracias!
Nat
.

..

 

[Ken Wright]

You can't use it as you have stated, as you are referencing a range. Try the following, assuming
you actually do want the SUM of those cells B88

=SUM('Office Copy'!B88)

 

[Guest]

Thank you for responding!!! What I am linking is a text
cell (company name, address, etc) to the invoice copy, but
when it's entered, instead of the name appearing a zero
appears instead.

Please, any ideas???

-----Original Message-----
You can't use it as you have stated, as you are

referencing a range. Try the following, assuming

 

[Ken Wright]

Are you linking all that to one cell, as if so then you need to concatenate the data, eg:-

=A1&" "&B1&" "C1, but using your references to each of the individual cells

Without a space between
='OFFICE COPY'!B8&'OFFICE COPY'!C8&'OFFICE COPY'!D8

With a space between
='OFFICE COPY'!B8&" "&'OFFICE COPY'!C8&" "&'OFFICE COPY'!D8

If you just want to return all 3 cells to another 3 cells, then put a link in to 1 cell, then just
copy it across to the next 2 cells as well.