Thank you. Is there a way to have it include the same formatting as
well?

On Wed, 19 Mar 2008 13:32:47 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

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


Gord Dibben MS Excel MVP

On Wed, 19 Mar 2008 11:46:59 -0700, spilparc wrote:

I want to start a new worksheet with the ending data from my old
worksheet. I'll continue to enter data into the old worksheet, but I
want it to copy into the new one as well.

I tried using sheet1!F384 for example, but all that does is put in the
date 1/9/00

Confused