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

 

[Simon Lloyd]

That explanation is very very confusing!, when you say DATES column yo
say you have quantities....etc are you getting Columns and Rows mixe
up?, in your example data there isn't a DATES column and if Feb 1...et
is the DATES column then for some reason it has Amount under it......I'
afraid you will have to try to explain a little clearer to get some hel

i have a fil

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

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



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

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

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

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

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

 

[Simon Lloyd]

MyShak, why not join our forums (shown in the link below) they'r
completely free, whilst making a post there you can attach a workbook s
we can actually see your structure and help you with that, if you d
join and post please post in this thread (link shown below) so tha
people who have been helping or following it can still continue to d
so

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 t
keep col name Item. I need to keep col name Qty and Amount. I want t
delete all other colomns i.e %ofdep, AvgCost, COGS, AvgCOGS. There ar
several blank titles colomns also which i want to delete
==================================================================
Item Feb
Feb2 Feb3 and so on
Qty Amount %ofDep AvgCost COGS Qty Amount %ofDep AvgCos
COGS Qty Amount %ofDep AvgCost COG
cup 1 3 3 234 23 4 4 3 23
23 2 3 3 234 2
coffee 2 5 3 23 56 5 2 3 23
23 4 3 3 234 2
paper 3 2 3 23 56 7 8 3 23
23 5 3 3 234 2

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


Required fil

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

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

Hopefully it should be clear. If not let me know

I am looking for macro for that. Any advice would be highl
appreciate

I have On Mar 4, 11:08*pm, Simon Lloyd <Simon.Lloyd
(e-mail address removed)> wrote


Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1
(http://www.thecodecage.com/forumz/showthread.php?t=71472

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com