It seems you have a lot of data in one column in groups separated by blank
rows There seem to be blank rows between each row with Data and 2 or more
blank rows between each set of data which is presumably a record. Each
record seems to have 3 fields. Is it possible for any of the fields to ever
be blank? Will the first two fields of each record always commence 'CVL'
with the second field always having a space after the 'CVL'. Will the third
fields always commence with 'FM-'
How many records would you typically have to deal with? How often will this
occur?
But, Most important: What do you want to do with this data?
Best Regards
David Grugeon
Excel VBA Group Moderator
-----Original Message-----
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of Siraj Momin (BTG)
Sent: Wednesday, 20 July 2011 8:04 PM
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA]
Dear Members
Can any one help me on this
sheet named "cat"
CATCODE
CATCODE-DESC
FORMNO
CVL01
CVL DESC01
FM-0001
CVL01
CVL DESC01
FM-0002
CVL01
CVL DESC01
FM-0003
CVL02
CVL DESC02
FM-0004
CVL02
CVL DESC02
FM-0005
CVL02
CVL DESC02
FM-0006
CVL02
CVL DESC02
FM-0007
sheet named "id"
ID
DESC
CATCODE
A
DESC A
CVL01
B
DESC B
CVL02
C
DESC D
CVL02
D
DESC E
CVL01
sheet named "RESULT"
ID
DESC
CATCODE
CATCODE-DESC
FORMNO
A
DESC A
CVL01
CVL DESC01
FM-0001
A
DESC A
CVL01
CVL DESC01
FM-0002
A
DESC A
CVL01
CVL DESC01
FM-0003
D
DESC C
CVL01
CVL DESC01
FM-0001
D
DESC C
CVL01
CVL DESC01
FM-0002
D
DESC C
CVL01
CVL DESC01
FM-0003
B
DESC B
CVL02
CVL DESC02
FM-0004
B
DESC B
CVL02
CVL DESC02
FM-0005
B
DESC B
CVL02
CVL DESC02
FM-0006
B
DESC B
CVL02
CVL DESC02
FM-0007
C
DESC D
CVL02
CVL DESC02
FM-0004
C
DESC D
CVL02
CVL DESC02
FM-0005
C
DESC D
CVL02
CVL DESC02
FM-0006
C
DESC D
CVL02
CVL DESC02
FM-0007
[Non-text portions of this message have been removed]
------------------------------------
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------Yahoo! Groups Links
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar