You could try posting in .programming for a vba solution if no one else jumps
in here with the vba for you

=IF(Sheet1!A1="","",Sheet1!A1)
.. but I am not sure why this is needed.
If you mean, why not just use: =Sheet1!A1 ?
That's because blank source cells will be evaluated by Excel & returned as
zeros. The IF construct above suppresses these zero returns by returning
"blanks", viz.: "" which gives a neater look
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Brad" wrote:
Max,

Thanks again for the assistance. I have made some progress on this little
project. The tricky part is that the number of cells in Sheet1 is going to
vary over time. I plan to experiment with VBA to handle this.

Also,

I understand what the

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

does, but I am not sure why this is needed.