copying from worksheet to worksheet

  • Thread starter Thread starter spilparc
  • Start date Start date
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
 
Thank you. Is there a way to have it include the same formatting as
well?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot copy worksheet to another file 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy Cells from multiple Worksheets in same workbook. 2
Excel Move or Copy Stopped Working? 0
copying worksheet including graphs to new worksheet 9
Copy absolute formulas 1
Copy a range data from 1 sheet to multiple selected sheets 1
Linking data from worksheet to worksheet 6

Back
Top