R
rqy99g
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
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