copying from worksheet to worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

spilparc - 19 Mar 2008 19:46 GMT

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

Reply to this Message

Gord Dibben - 19 Mar 2008 21:32 GMT

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

Gord Dibben MS Excel MVP

>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
[quoted text clipped - 4 lines]
>
>Confused

Reply to this Message

spilparc - 19 Mar 2008 22:43 GMT

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

>=IF(Sheet1!F384="","",Sheet1!F384)
>
[quoted text clipped - 8 lines]
>>
>>Confused

Reply to this Message

Gord Dibben - 19 Mar 2008 23:22 GMT

Not without some added work.

Formatting cannot be linked.

You could use some Conditional Formatting to format the source cell and use the
same CF for the target cell.

But only visual formatting like Patterns, Fonts, Borders, not formatting like
number formatting or dates or similar.

Gord

>Thank you. Is there a way to have it include the same formatting as
>well?
[quoted text clipped - 11 lines]
>>>
>>>Confused

Reply to this Message