How to get a copied sheet to update?

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
 
G

Gord Dibben

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
 
Top