hi,
formulas return values. they cannot perform actions like
copy and pasted. sorry
this could possible be done with a macro.

-----Original Message-----
In excel 2003 can a formula be constructed that will copy
a cell into a new
spreadsheet if there is text in the original spreadsheet
cell but will also
repeat the last used cell within a column if the original
spreadsheet is
empty?
.