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

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.
3ok...@thecodecage.com> wrote:
> That explanation is very very confusing!, when you say DATES column you
> say you have quantities....etc are you getting Columns and Rows mixed
> up?, in your example data there isn't a DATES column and if Feb 1...etc
> is the DATES column then for some reason it has Amount under it......I'm
> afraid you will have to try to explain a little clearer to get some help
> on this.
>
> myshak;256056 Wrote:
>
>
>
> > 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
>
> Regards,
> Simon Lloyd
> 'The Code Cage' (http://www.thecodecage.com)
> ------------------------------------------------------------------------
> Simon Lloyd's Profile:http://www.thecodecage.com/forumz/member.php?userid=1
> View this thread:http://www.thecodecage.com/forumz/sh...ad.php?t=71472