I have one Excel workbook. Within it I have five worksheets tabbed at the bottom. Each worksheet has a cell that sums the range in a certain column... it's a currency column that totals all currency entered into in the column. I would like a sixth worksheet - within this workbook - to be the one that gathers the other five cells holding the sum for each worksheet into one "total" cell.
How do I set that up?
