Getting a mirror image

J

John Bordieri

Hi
How do I get the entire excel spreadsheet to mirror image to a new
worksheet.?

I'm looking to do a mirror image of my employee schedule. Sheet 1 will
contain info only useful to me (the last 3 columns) and sheet 2 will have
only the scheduled hours which I will print out and give each employee. I'm
know I can copy and paste, but that's not what I'm looking to do. I want to
be able to type on sheet one and the info will be added to sheet two
automatically.

I will email a copy of the schedule to you if it will be easyier to explain.
Thank you in advance. John
 
E

Earl Kiosterud

John,

One way would be to hide the unwanted columns, print it, then unhide them.
Recording a macro would be useful if you do this a lot.

Don's suggestion to use formulas will work, but you'll need to include
formulas as far down as you'd ever have rows, making it a bit error-prone
unless your formulas went all the way to the bottom of the sheet. A
potential problem with that is that the formulas will yield zeroes unless
you turn them off (Tools - Options - View - Zero values). You may still get
a lot of unwanted empty pages when you print.

Earl Kiosterud
www.smokeylake.com
 
K

kletcho

Sounds like you want custom views. Like Earl was saying you can hide
the columns the columns that don't apply to create your view then go to
view -- custom views -- add... and give your view of the current
spreadsheet a name. Then format the spreadsheet how you want it for
your employees and go back to custom views to name a second view. Then
you can swap back and forth between the views of the spreadsheet by
selecting a view.
 
Top