Delete colomns and rows
 

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

Delete colomns and rows
 

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

Delete colomns and rows
 

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

Delete colomns and rows
 

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

myshak;259331 Wrote:
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.
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' ('The Code Cage' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile:'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread:'Delete colomns and rows - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...ad.php?t=71472)


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