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