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.