In your sheet: Spend Plan,
Put this slightly amended* into cell A3:
=IF('AD HOC ALL'!A3="","",'AD HOC ALL'!A3)
*added the apostrophes
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik
---
"Sher" wrote in message
...
Here is the formula:
Spend Plan A3: =IF(AD HOC ALL!A3="","", AD HOC ALL!A3)