copying from worksheet to worksheet

S

spilparc

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
 
G

Gord Dibben

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
 
Top