Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Between Sheets and #Value! Error
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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Between Sheets and #Value! Error
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, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Between Sheets and #Value! Error
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, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Between Sheets and #Value! Error
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) "Melanie" wrote in message ... 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, |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Between Sheets and #Value! Error
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 -- Regards, Peo Sjoblom "Bob Phillips" wrote in message ... 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) "Melanie" wrote in message ... 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, |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Between Sheets and #Value! Error
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) "Peo Sjoblom" wrote in message ... 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 -- Regards, Peo Sjoblom "Bob Phillips" wrote in message ... 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) "Melanie" wrote in message ... 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, |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Between Sheets and #Value! Error
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 "Melanie" wrote: 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking a name across 30 sheets. | Excel Worksheet Functions | |||
Need Help Linking Sheets | Excel Discussion (Misc queries) | |||
Linking Sheets | Excel Discussion (Misc queries) | |||
Need help with linking sheets. | Excel Discussion (Misc queries) | |||
Linking sheets | Excel Discussion (Misc queries) |