Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking - destination cell shows "0" instead of value in source ce
I'm trying to create a summary worksheet to show an overview of our
departments annual leave. Each member of the dept has a separate sheet to record their leave on and we need another one to summarise. However, when I try and create links from the individual (source) sheets to the summary (destination) sheet, I get "0" displayed in the cell rather than what's in the cell (should be displaying a date) All cells in all sheets are formatted as general. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking - destination cell shows "0" instead of value in sourcece
Post the formula you are using.
Pete On Jan 7, 10:51*am, lh1 wrote: I'm trying to create a summary worksheet to show an overview of our departments annual leave. Each member of the dept has a separate sheet to record their leave on and we need another one to summarise. However, when I try and create links from the individual (source) sheets to the summary (destination) sheet, I get "0" displayed in the cell rather than what's in the cell (should be displaying a date) All cells in all sheets are formatted as general. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking - destination cell shows "0" instead of value in source ce
Hi,
There is apparently a problem with the formula you typed, don't type it. Move to the cell on the summary sheet where you want the first result and type = then click the sheet tab for the first employee and then click on the cell with the value you want returned, then press Enter. You will have a formula like ='Sheet 1'!A1 Repeat for each employee. -- If this helps, please click the Yes button Cheers, Shane Devenshire "lh1" wrote: I'm trying to create a summary worksheet to show an overview of our departments annual leave. Each member of the dept has a separate sheet to record their leave on and we need another one to summarise. However, when I try and create links from the individual (source) sheets to the summary (destination) sheet, I get "0" displayed in the cell rather than what's in the cell (should be displaying a date) All cells in all sheets are formatted as general. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking - destination cell shows "0" instead of value in sourc
That's what I was doing - I didn't type the formula.
However, I managed to work out that the problem was that the cell I was linking from was actually two merged cells. When I changed the cell reference in the formula to the first of the merged cells, it worked fine. Many thanks for your responses though! "Shane Devenshire" wrote: Hi, There is apparently a problem with the formula you typed, don't type it. Move to the cell on the summary sheet where you want the first result and type = then click the sheet tab for the first employee and then click on the cell with the value you want returned, then press Enter. You will have a formula like ='Sheet 1'!A1 Repeat for each employee. -- If this helps, please click the Yes button Cheers, Shane Devenshire "lh1" wrote: I'm trying to create a summary worksheet to show an overview of our departments annual leave. Each member of the dept has a separate sheet to record their leave on and we need another one to summarise. However, when I try and create links from the individual (source) sheets to the summary (destination) sheet, I get "0" displayed in the cell rather than what's in the cell (should be displaying a date) All cells in all sheets are formatted as general. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking - destination cell shows "0" instead of value in sourc
Now you see one of the *many* reasons why experts here keep recommending
that you avoid merged cells like the plague. -- David Biddulph "lh1" wrote in message ... That's what I was doing - I didn't type the formula. However, I managed to work out that the problem was that the cell I was linking from was actually two merged cells. When I changed the cell reference in the formula to the first of the merged cells, it worked fine. Many thanks for your responses though! "Shane Devenshire" wrote: Hi, There is apparently a problem with the formula you typed, don't type it. Move to the cell on the summary sheet where you want the first result and type = then click the sheet tab for the first employee and then click on the cell with the value you want returned, then press Enter. You will have a formula like ='Sheet 1'!A1 Repeat for each employee. -- If this helps, please click the Yes button Cheers, Shane Devenshire "lh1" wrote: I'm trying to create a summary worksheet to show an overview of our departments annual leave. Each member of the dept has a separate sheet to record their leave on and we need another one to summarise. However, when I try and create links from the individual (source) sheets to the summary (destination) sheet, I get "0" displayed in the cell rather than what's in the cell (should be displaying a date) All cells in all sheets are formatted as general. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
When I type "13" the spreadsheet shows "14." Possibilities? | Excel Discussion (Misc queries) | |||
In Excel a cell formatted "currency" shows "######" help! | Excel Worksheet Functions |