Hiding dates
 

Hi,

I have created a workbook which has a number of fields in worksheet one.
When data is keyed into this sheet the two other sheets in the workbook are
populated.

One of the sections requires dates to be put in.
When no date is entered the other sheets default to "00/01/1900". is there
a way of keeping these cells blank until a date is entered in the first sheet?

Thanks,
bryan

Hiding dates
 

Hi

The usual way is to use something like this:
=IF(Sheet1!B90,Sheet1!B9,"")

Hope this helps.

Andy.

"Bryan" wrote in message
...
Hi,

I have created a workbook which has a number of fields in worksheet one.
When data is keyed into this sheet the two other sheets in the workbook
are
populated.

One of the sections requires dates to be put in.
When no date is entered the other sheets default to "00/01/1900". is
there
a way of keeping these cells blank until a date is entered in the first
sheet?

Thanks,
bryan

Hiding dates
 

Are you using formula to populate the other sheet? If so, test the value
first,,like this

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bryan" wrote in message
...
Hi,

I have created a workbook which has a number of fields in worksheet one.
When data is keyed into this sheet the two other sheets in the workbook
are
populated.

One of the sections requires dates to be put in.
When no date is entered the other sheets default to "00/01/1900". is
there
a way of keeping these cells blank until a date is entered in the first
sheet?

Thanks,
bryan

Hiding dates
 

Thanks Andy/Bob - Problem solved!

Cheers,
Bryan

"Andy" wrote:

Hi

The usual way is to use something like this:
=IF(Sheet1!B90,Sheet1!B9,"")

Hope this helps.

Andy.

"Bryan" wrote in message
...
Hi,

I have created a workbook which has a number of fields in worksheet one.
When data is keyed into this sheet the two other sheets in the workbook
are
populated.

One of the sections requires dates to be put in.
When no date is entered the other sheets default to "00/01/1900". is
there
a way of keeping these cells blank until a date is entered in the first
sheet?

Thanks,
bryan