automatically making a copy of a sheet
 

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...


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=534908