How to get a copied sheet to update?

  • Thread starter Thread starter mcr1
  • Start date Start date
M

mcr1

I made a copy of sheet 1, and it is names sheet 2. How can I get th
data that I entered in sheet 1 to copy or update directly into the 2n
sheet. Like I said the sheet are identical, sheet for sheet. Onc
that is done, how can I set it up so only the 2nd sheet prints? Thank
in advance!

Mile
 
To get a "linked" copy of sheet1 that updates.

With sheet1 active.......

Hit CRTL + A to select all cells.

Copy then switch to sheet2 and Paste Special>Paste Link>OK>Esc.

As far as printing, just select sheet2 and File>Print>Active Sheet.

Gord Dibben Excel MVP
 
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

Help to create a macro 2
Need to merge worksheets - Excel 2003 0
Copying data to the next blank row 0
How to insert new worksheet based on # of rows in a data sourch 2
Copying Range From One Sheet to Another 6
Merge Multiple workbook sheets into one workbook 0
copy rows from one Data sheet to another sheet based on cell conte 2
Copy formula from various sheets 2

Back
Top