How Do I Copy a Table Data to a Report, Sum some Columns, Omitting others?

[TedJL]

I recall seeing this operation done very simply but don't recall the function or macro. Suppose I have the table A1..G5 as a list of materials and manhours to produce them. After selecting quantities, I want to extract only those rows that are not zero and omit certain other columns, i.e. columns D and E in the example, and paste them somewhere in summary form, such as in columns H through L in the example. I also want the subtotal columns summed for the grand total at the bottom. I think this was done using a copy and paste function or macro or combo of both. It was in an MS DOS version of Excel, and the pasting range had the desired column headers predefined before the macro was initiated. I believe the first line under each Subtotal column (K3 and L3 in the example) had a pre-filled zero, but don't know if it was from a formula or what. That's all I remember. Any ideas?

A

B

C

D

E

F

-->

H

I

J

K

L

1

Main Tbl

-->

2

Qty

Descr.

Units

MH/Unit

$/Unit

Subtotal MH

Subtotal $ Mat'l

-->

QTY

Descr.

Units

Subtot. MH

Subtot. $ Mat'l

3

1

WidgetA

Ea

.25

0.33

=A3*D3

=A3*E3

-->

1

WidgetA

Ea

.25

.33

4

WidgetB

Ea

.25

0.33

=A4*D4

=A4*E4

-->

2

WidgetB

Ea

.35

.41

5

2

WidgetC

Ea

.35

.41

=A5*D5

=A5*E5

-->

Grand Tot.

=@Sum(K3..K4)

=@Sum (L3..L4)



<tbody>
</tbody>

 

[TedJL]

Sorry I omitted the designator for column G. And cell I4 should read "WidgetC" not "WidgetB".