Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I move information between worksheets?
I have 12 separate spreadsheets that sum dollar amounts in a single cell. I
created a thirteenth spreadsheet which summarizes all the info. I want to input a cell formula that will bring the final value into the "Summary" spreadsheet but can't figure out the right formula to use. |
#2
|
|||
|
|||
=Sheet2!A1 and change sheet name and cell reference to suit.
-- Ian -- "Nocomputergeek" wrote in message ... I have 12 separate spreadsheets that sum dollar amounts in a single cell. I created a thirteenth spreadsheet which summarizes all the info. I want to input a cell formula that will bring the final value into the "Summary" spreadsheet but can't figure out the right formula to use. |
#3
|
|||
|
|||
Hi
If you are wanting to total the same cell across the 12 sheets, then on Sheet 13 =SUM(Sheet1:Sheet12!A1) Or, if you want to vary the range of sheets being summed, then Create a blank sheet called First, and another called Last and use the formula =SUM(First:Last!A1) Make sure that Sheet13 is outside of the range First and Last, but by dragging the Last sheet (Right mouse click on sheet tab and drag), then you can vary the number of sheet being summed. Regards Roger Govier Nocomputergeek wrote: I have 12 separate spreadsheets that sum dollar amounts in a single cell. I created a thirteenth spreadsheet which summarizes all the info. I want to input a cell formula that will bring the final value into the "Summary" spreadsheet but can't figure out the right formula to use. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move between worksheets | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Copying information from multiple worksheets into one | Excel Discussion (Misc queries) | |||
Aggregating categorized information from several worksheets | Excel Worksheet Functions | |||
How to search multiple worksheets in a workbook for information? | Excel Discussion (Misc queries) |