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" wrote:

More detail?

Sample data, and the formulae?

--
HTH

Bob

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

"Melanie" wrote in message
...
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,