Subtracting Two Tables

[wolf_tracks]

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 A1010.

 

[wolf_tracks]

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

Copy across to D7 then down to A1010.

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.

--
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/>

 

[wolf_tracks]

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.

--
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]

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".