Subtracting Two Tables

[wolf_...@invalid.com]

Is it possible to easily subtract two tables and place the results into
another table? I have two 4x4 tables. The left corners are at A1 and F1.
I would like the result to appear in the corner at A7.
--
Wayne Watson (Watson Adventures, Prop., Nevada City, CA)

(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39� 15' 7" N, 121� 2' 32" W, 2700 feet

Solid waste produced to generate electricity per person
over a lifetime:
Nuclear power -- 2 pounds in a coke can
Fossil (coal) fuel -- 68.5 tons in six 12-ton RR cars

-- Power to Save the World, Gwyneth Cravens

Web Page: <www.speckledwithstars.net/>

[T. Valko]

In A7 enter =A1-F1 or =F1-A1.

Copy across to D7 then down to A10:D10.

--
Biff
Microsoft Excel MVP

<wolf_...@invalid.com> wrote in message
news:eqsJ8nJ...@TK2MSFTNGP02.phx.gbl...

[wolf_...@invalid.com]

T. Valko wrote:
> In A7 enter =A1-F1 or =F1-A1.
>
> Copy across to D7 then down to A10:D10.
>

I don't seem to be able copy down from d7. I'm guessing when I settle on
a7, after entering =f1-a1, that the little cross in the lower right-hand
corner is some mechanism for copying. All works well for row a7 to to d7.

[wolf_...@invalid.com]

wolf_...@invalid.com wrote:
> T. Valko wrote:
>> In A7 enter =A1-F1 or =F1-A1.
>>
>> Copy across to D7 then down to A10:D10.
>>
> I don't seem to be able copy down from d7. I'm guessing when I settle on
> a7, after entering =f1-a1, that the little cross in the lower right-hand
> corner is some mechanism for copying. All works well for row a7 to to d7.
>

Ah, I had to copy down each column from the first row, 7. Thanks.

[T. Valko]

>the little cross in the lower right-hand corner
>is some mechanism for copying.

Yes, it's called the fill handle, that small black square in the lower-right
corner of the selection. When you hover your mouse over it the cursor
changes to a "skinny plus sign".

--
Biff
Microsoft Excel MVP

<wolf_...@invalid.com> wrote in message
news:%23POhgSL...@TK2MSFTNGP04.phx.gbl...