Linking Between Sheets and #Value! Error

[Guest]

Hi,

I am linking info from one cell in one worksheet to another cell in a second
worksheet in the same workbook. This particular field is a phone number and
has been formatted on the first sheet as such. The phone number has been
filled out on the first sheet and when I link it to the second sheet I get
the #Value! Error. Can anyone help me figure out what the problem is. Other
links between the 2 are working fine.

Thanks,

 

[Bob Phillips]

More detail?

Sample data, and the formulae?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Here is the formula to link the one sheet into the second sheet and the cells
to copy. ='Project Prioritization Form'!D28:G28 I have done this many many
times but for some reason this isn't working when others are. As I stated
the text in the cells I am wanting to link to the second sheet is a date.

 

[Bob Phillips]

You can't do it that way, you have to reference just the one cell and then
copy it across.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Peo Sjoblom]

Actually it is possible, if you select four cells across (or four cells down
and use TRANSPOSE) and array enter the formula it will work but I doubt it
was that the OP had in mind

 

[Bob Phillips]

I know it can be done, but I think that is getting far too heavy for this
level of user.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Hi,

Try to trim the data, sometimes one set of data has a couple of spaces at
the end, the formulas read these spaces and wont make a match.

select a clean cell, type =Trim(select cell with number), once trimed you
will need to paste the data without the formula:

Copy
Paste special
Values

Sassy