Empty Cells

Hi

I have a table which is large and I want to have a summary sheet with much less info on it.

I use the following reference from one worksheet to the next =open!A1 etc.

When empty cells are referenced in my summary worksheet they either have a 0, or if it is a date colum then i get 00/01/1900.

My question is how do I get it to return blank cells?

Example 1 (Open worksheet)
Surname First Date Number
Smith John 01/02/2005 01204 593215
Jones Peter 07/06/2005 07745 563214
Taylor Paul 21/03/2006 01204 698221


Example 2 (Summary worksheet)

Surname Date Number
Smith 01/02/2005 01204 593215
Jones 07/06/2005 07745 563214
Taylor 21/03/2006 01204 698221
0 00/01/1900 0
0 00/01/1900 0
0 00/01/1900 0
0 00/01/1900 0
0 00/01/1900 0

I hope that makes sense!

Regards

Simon

PS I'm using MS Excel 2002

=IF(open!A1="","",open!A1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"rqy99g" <[email protected]> wrote in
message news:[email protected]...
>
> Hi
>
> I have a table which is large and I want to have a summary sheet with
> much less info on it.
>
> I use the following reference from one worksheet to the next =open!A1
> etc.
>
> When empty cells are referenced in my summary worksheet they either
> have a 0, or if it is a date colum then i get 00/01/1900.
>
> My question is how do I get it to return blank cells?
>
> Example 1 (Open worksheet)
> Surname First Date Number
> Smith John 01/02/2005 01204 593215
> Jones Peter 07/06/2005 07745 563214
> Taylor Paul 21/03/2006 01204 698221
>
>
> Example 2 (Summary worksheet)
>
> Surname Date Number
> Smith 01/02/2005 01204 593215
> Jones 07/06/2005 07745 563214
> Taylor 21/03/2006 01204 698221
> 0 00/01/1900 0
> 0 00/01/1900 0
> 0 00/01/1900 0
> 0 00/01/1900 0
> 0 00/01/1900 0
>
> I hope that makes sense!
>
> Regards
>
> Simon
>
> PS I'm using MS Excel 2002
>
>
> --
> rqy99g
> ------------------------------------------------------------------------
> rqy99g's Profile:
http://www.excelforum.com/member.php...o&userid=33032
> View this thread: http://www.excelforum.com/showthread...hreadid=528518
>

Thanks, you make it look easy!!

Hi can any of you guys help with this one?

http://groups.google.co.uk/group/mic...c2ae10fd8d5146

Cheers.

I did.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"GMCN" <[email protected]> wrote in message
news:[email protected]...
> Hi can any of you guys help with this one?
>
>
http://groups.google.co.uk/group/mic...c2ae10fd8d5146
>
> Cheers.
>

Try...

=IF(Open!A1<>"",Open!A1,"")

Hope this helps!

In article <[email protected]>,
rqy99g <[email protected]> wrote:

> Hi
>
> I have a table which is large and I want to have a summary sheet with
> much less info on it.
>
> I use the following reference from one worksheet to the next =open!A1
> etc.
>
> When empty cells are referenced in my summary worksheet they either
> have a 0, or if it is a date colum then i get 00/01/1900.
>
> My question is how do I get it to return blank cells?
>
> Example 1 (Open worksheet)
> Surname First Date Number
> Smith John 01/02/2005 01204 593215
> Jones Peter 07/06/2005 07745 563214
> Taylor Paul 21/03/2006 01204 698221
>
>
> Example 2 (Summary worksheet)
>
> Surname Date Number
> Smith 01/02/2005 01204 593215
> Jones 07/06/2005 07745 563214
> Taylor 21/03/2006 01204 698221
> 0 00/01/1900 0
> 0 00/01/1900 0
> 0 00/01/1900 0
> 0 00/01/1900 0
> 0 00/01/1900 0
>
> I hope that makes sense!
>
> Regards
>
> Simon
>
> PS I'm using MS Excel 2002