| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| colomns got swoeched | New Users to Excel | |||
| re-name colomns i.e A,B,C, etc | Excel Discussion (Misc queries) | |||
| how to merge 2 colomns | Excel Worksheet Functions | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
| how to get more than 256 colomns in excel sheet ? | Excel Discussion (Misc queries) | |||
Hybrid Mode
