Thread: return of blank
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default return of blank

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Darts via OfficeKB.com" <u19990@uwe wrote in message
news:a22b342be6256@uwe...
U guys are great!!!!!!!! thanks much

T. Valko wrote:
Try this...

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

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

[quoted text clipped - 6 lines]

thanks


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201001/1