copying from worksheet to worksheet
=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
|