Getting a mirror image

  • Thread starter Thread starter John Bordieri
  • Start date Start date
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
 
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
 
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.
 
Back
Top