OK Siraj
Send it to me (yahoo@grugeon.com.au) and I will see what I can do. It may
not be straight away because I am in Australia and going to sleep now.
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 9:29 PM
To: ExcelVBA@yahoogroups.com
Subject: RE: [ExcelVBA]
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
----------------------------------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