View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shazza
 
Posts: n/a
Default How do I bring totals from one worksheet onto the second worksheet

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?