Print area ?

[LAD]

I have several sheets in my workbook that transfer totals
to a sheet. The number of entries in each sheet varies,
what do i need to do to have the totals transfer wtih out
changing the formula each time.
Thanks

 

[Frank Kabel]

Hi
you may provide some more detail about the layout of your spreadsheet

 

[Guest]

O.K. Page 1 has totals from several different pages i.e.
page 2 has commissions, this page can have a lot of
different entries. I want the total from page 2 to go to
page 1. I could put =sum (b1:b1000) and have B1000 go to
page 1 but I thought there might be an easier way. Does
this make sense.
Thanks