Linking two spreadsheets with different print format

M

mike

Hello,
Ok, here is the story lets say I have a two spreads one called a.xls and
is formated to print on a ll x17 paper and the other to be printed on a 8.5
x 11 paper which is called b.xls. The format are slightly different because
the headings for the ll x 17 are at different rows then the 8.5 x 11 which
makes the spreadsheet different also the page breaks are different. Since I
don't like the print area command I was wondering is there away to link the
11 x 17 format to the 8.5 x 11 format so that if I make one change in the
data in master 11 x 17 page it will show up in the 8.5 x 11.
thanks for your help
 
Top