in excel can one repeat the text from a the last used column cell.

M

Millard

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?
 
G

Guest

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