linking problem REALLY NEED SOMEONE TO HELP ME!!

  • Thread starter Thread starter Nat :\)
  • Start date Start date
N

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'!B8:D8 (example) but for the Invoice
sheet gives a value of "0" instead of the information
requested. PLEASE HELP!!!

Muchos Gracias!
Nat
.
Click to expand...
..
 
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 B8:D8

=SUM('Office Copy'!B8:D8)
 
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
Click to expand...
referencing a range. Try the following, assuming
 
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.
 
Back
Top