Hi Biff,
Thanks for your answer, I don't completely understand how to do the formula,
so can you please try to help me again.

Worksheet 1 - Expenses ( 2 columns)

Supplies Entertainment
100 50
200 60

300 110

Worksheet 2 - Monthly Totals

Supplies
Entertainment

How do I get the totals on my Expenses worksheet to go directly into my
Monthly Totals worksheet? Supplies, into column b row 1 and entertainment
into column b, row 2?

I'm really new at this and this calculation has me baffled. Thanks for your
help!

Shazza

"Biff" wrote:

Hi!

Assume the headers are in order on both sheets:

Sheet1:

Header1;Header2;Header3, etc

Sheet2:

Header1
Header2
Header3
etc

In Sheet2 in the cell to the right of Header1 enter this formula and copy
down as needed:

=INDEX(Sheet1!A$11:F$11,ROWS($1:1))

Sheet1!A$11:F$11 is the range of the totals. Adjust to suit.

Biff

"Shazza" wrote in message
...
I have an Excel document with 2 worksheets.
The first worksheet has 20 columns with headings and then dollar figures
in
each cell and a total of each column at the bottom.
The 2nd worksheet has the column headings listed virtically on the page.
I
would like the TOTAL of each column on the first worksheet to go into the
appropriate cell on the second worksheet. How do I do this?