Actually data is more this is the reason I generate this sample data but
there no blank row in my table I don't know how it changes the format
when reaches this board it is in formatted table.
Just I will try to elaborate to you here.
1. I have three sheet named 1) cat 2) id 3) result
2. In cat sheet categories are defined (in this sheet 3 columns
names are : CATCODE, CATCODE-DESC, FORMNO)
3. In id sheet id's are defined and categories are assigned as
defined in cat sheet. defined (in this sheet 3 columns names are : ID,
DESC , CATCODE)
4. In result sheet I want the combination of cat & id sheets (in
this sheet columns are ID, DESC, CATCODE, CATCODE-DESC, FORMNO)
5. Suppose in cat sheet I have 2 records with same CATCODE,
CATCODE-DESC BUT FORMNO DIFFERENT (EXAMPLE: FM-1037-001, FM-1037-002)
6. What I want is if I assign this CATCODE against any of the ID
in my sheet my result sheet should added with that particular id and
those 2 FORMNO should be reflected against that id, remember ID AND
CATCODE are plenty that is why I need automatic generation
Can I send the excel file to your personal email because attachments are
not allowed in this group.
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
Behalf Of David Grugeon
Sent: 20 July 2011 02:56 PM
To: ExcelVBA@yahoogroups.com
Subject: RE: [ExcelVBA]
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%40yahoogroups.com>
[mailto:ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com> ]
On Behalf
Of Siraj Momin (BTG)
Sent: Wednesday, 20 July 2011 8:04 PM
To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.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
[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
----------------------------------
Tidak ada komentar:
Posting Komentar