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.

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.

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.

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.

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.