Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Subtract entire sheet?
I have two sheets in the same format. Is there a quick way to subtract the
entire sheet one from the other or do I have to resort to just doing a subtract formula and copying to relevant cells? Thanks! |
#2
|
|||
|
|||
You want to subtract the total of one sheet from another?
=SUM(Sheet2!1:65536)-SUM(Sheet1!1:65536) entered in a third sheet or else you would get circular reference errors I doubt that is what you want though, maybe you could clarify? Regards, Peo Sjoblom "jennifer" wrote: I have two sheets in the same format. Is there a quick way to subtract the entire sheet one from the other or do I have to resort to just doing a subtract formula and copying to relevant cells? Thanks! |
#3
|
|||
|
|||
"jennifer" wrote in message
... do I have to resort to just doing a subtract formula and copying to relevant cells? Yes. In Sheet3!A1, enter Sheet1!A1-Sheet2!A1 Copy to suit. -- Vasant |
#4
|
|||
|
|||
Copy the pertinent range on the sheet you want to subtract. Move to
theother sheet and select the top left corner of the same range. From the menu select EditPaste SpecialSubtract "jennifer" wrote in message ... I have two sheets in the same format. Is there a quick way to subtract the entire sheet one from the other or do I have to resort to just doing a subtract formula and copying to relevant cells? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The Aarow keys move the entire sheet instead of to the next cell | Charts and Charting in Excel | |||
My entire sheet moves instead of the cursor. What to do? | Excel Discussion (Misc queries) | |||
Linking to an Entire Sheet | Links and Linking in Excel | |||
Referencing an Entire Sheet | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |