Only a couple of the columns are totals. It is a running list of stocks
purchased by date purchased. Some total shares.. while others are just share
price.


"Pete" wrote:

Debbie,

I would suggest putting your totals formula (I assume that is what they
are) on the top row of each sheet, so that they will be something like:

=SUM(A3:A500)

allowing row 2 for headings and up to 500 for data. This way the
formulae in your summary sheet will always get the data from row 1 of
the detailed sheets. In the detailed sheets you can arrange for the
range to be as large or as small as the data you expect.

Hope this helps.

Pete