On the second sheet :
=Sheet1!A1
or if you want blanks to stay blank instead of reading zero then:
=IF(Sheet1!A1<"",Sheet1!A1,"")


"Lee R. Crawford" wrote:

I am wanting to keep a running sum for a "Year to Date" column on an
Apartment ledger I keep using Excel. I would like to know how to combine a
single cell from one worksheet to the other in the same workbook.