automatically making a copy of a sheet

S

starguy

i have a data in a sheet of one page only and i take print of this sheet
on two pages to get large view. i want the same data on another sheet to
take a print on one page only.
it can be done by copy and pasting to other sheet and adjusting print
area for one page.
but i want that data of one sheet should be automatically updated on
other sheet so that i could take print immediately of the same data in
two ways i-e one on two pages and other is on one page.

any way to do this...
 
Top