Thread: return of blank
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Darts via OfficeKB.com Darts via OfficeKB.com is offline
external usenet poster
 
Posts: 29
Default return of blank

Ok in sheet a i have a date in cell (a2) # hrs in cell (b2)
On Sheet b i cell a2 to auto populate once i fill out sheet a and
autopopulate #hrs as well. I can get it to do that however when i copy the
formula down in sheet b for a date the return is 1/0/00 i do not want
anything in that cell unless i input date on the first sheet.

I hope you understand what i am trying to do

thanks

--
Message posted via http://www.officekb.com