Delete colomns and rows

[myshak]

i have a file

Item Feb 1 - 4, 07
Qty Amount % of Dep Avg Cost COGS Avg COGS

A 21.00 1,186.86 3.55% 56.52 315.00 15.00
A-4845 8.00 205.92 0.62% 25.74 0.00 0.00



File It has two main col Item and DATES. Under Dates col. it has qty
amount price etc. It also has emtply col.

I need to keep Item Col. I need to keep only QTY AND Amount under
Dates col. I need to delete all other columns. Keep in mind there
are several main col with DATES. Under these col i only need to keep
QTY and AMOUNT COL.

I am looking for macro for that. Any advice would be highly appreciated

 

[myshak]

Sorry for the confusion.
I have following file. Important Each col except "item" contains sub-
colomns (i.e Qty Amount %ofDep AvgCost COGS AvgCOGS). I need to
keep col name Item. I need to keep col name Qty and Amount. I want to
delete all other colomns i.e %ofdep, AvgCost, COGS, AvgCOGS. There are
several blank titles colomns also which i want to delete.
===================================================================
Item Feb1
Feb2 Feb3 and so on.
Qty Amount %ofDep AvgCost COGS Qty Amount %ofDep AvgCost
COGS Qty Amount %ofDep AvgCost COGS
cup 1 3 3 234 23 4 4 3 234
23 2 3 3 234 23
coffee 2 5 3 23 56 5 2 3 234
23 4 3 3 234 23
paper 3 2 3 23 56 7 8 3 234
23 5 3 3 234 23

===================================================================


Required file

===================================================================
Item Feb1 Feb2 Feb3 and so on.
Qty Amount Qty Amount Qty Amount
cup 1 3 4 4 2 3
coffee 2 5 5 2 4 3
paper 3 2 7 8 5 3

===================================================================

Hopefully it should be clear. If not let me know.

I am looking for macro for that. Any advice would be highly
appreciated

I have On Mar 4, 11:08 pm, Simon Lloyd <Simon.Lloyd.