rjr
When you say you want those columns removed, do you mean deleted (as in
GONE) or merely hidden?
You say "process" and "capture". Do you mean you want ALL other rows
deleted (as in GONE) or merely hidden?
I take it that you want to keep all those rows that have, as the first 5
characters in Column F, any of the listed branches. Is that right?
When you say "process", what do you want done with the remaining rows?
What row holds the headers? HTH Otto
"rjr" wrote in message
news:HBckh.10418$_X.7893@bigfe9...
Others have helped me with this but my questions kept modifying it. This
is a request for all programming that I need to work on these worksheets.

I thank you in advance for any help offered.



I have an exported csv format opened in Excel. It consists of varying
numbers of columns with headers. I may have between 5 and 200 rows in this
document.

The layout is like this:

A B C D E F
G H I

ID STATUS AGING REP SUB REP CO CODE DATE
NAME FOL DATE

1 3454 OPEN 14 0 0 3DFGTYU
01 0 0

2 9876 OPEN 10 0 0 3DFGUYV
01 0 0

3 3354 OPEN 07 0 0 3DFGTYU
01 0 0

4 9976 OPEN 00 0 0 3DFGXYV
01 0 0

5 9344 OPEN 02 0 0 3DFGAIU
01 0 0

6 9556 OPEN 04 0 0 3DFGUYD
01 0 0



I would like to do the following if possible in coding:

Upon activating the macro I would like to remove columns I, H, G, E, D, B
& A. This leaves me with C & F remaining. As column shows there are
various codes located in this column. I need to process only the CO Code
that has 3DFGU; 3DFGV; 3DFGW AND 3DFGX. I always need to capture only
these main codes from the CO CODE column. Please note that the code I need
DOES NOT Include the last two letters that are shown in the column. This
code represents the main branch and the additional two letters indicate
sub branches. I have a need to sort main branch AND the sub branches, but
there can be as many as 24 sub branches. Any other codes outside of the
main ones should be eliminated.