"paste special" function

  • Thread starter Thread starter J D Maher
  • Start date Start date
J

J D Maher

I've created 13 Excel worksheets in one book. There is
one worksheet for each month of the year (with all of the
appropriate columns, summing and arrays). These all work
great. The 13th worksheet in the book is the summary or
totals page. What is the correct way to have the totals
from the individual monthly pages automatically
transferred to the summary page? And will these
automatically update when the monthly pages are changed?
 
On Sheet 13 in the appropriate cell, assuming the sheet is laid out
exactly the same as the other 12 sheets, use the formula
=SUM(Sheet1:Sheet12!A1) or whatever the cell reference is.

Hope this helps
Stuart
 
Let me be more specific. There are 5 totals from each
monthly sales sheet (worksheet) that I want to carry
forward to the 13th (Summary) worksheet. The summary
sheet is layed out by month, quarter, and annual. I'm
trying to get these 5 totals from each monthly page to
transfer to the summary page in the appropriate spots.
Then, lower down on the summary page, have the totals for
the quarter and the year automatically fill in based on
the totals that transferred from the 12 individual
monthly worksheets.
 
What I do in a case like this is create a "summary" section at the top
of each of the 12 input pages. The totals for monthly, quarterly and
annual from the input portion of the worksheet would automatically be
linked into this summary section. Then link your summary fields for
each page to the Summary Worksheet. Whenever there is a change made
to the 12 input pages, the Summary Worksheet should update
automatically. This is just a very basic way of getting the totals
you want, but it works.
 
Back
Top