"Jeremy" wrote:
How do I transfer cell data from one sheet to the next. The cell data
contains a SUM expression if that will make it more challenging?

On the face of it ..
Think you could use a simple link formula,
something like this in say, Sheet2's A1:
=IF(Sheet1!A1="","",Sheet1!A1)
Copy A1 across/fill down as desired to cover the link area
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---