J
jay
Hi,
I am a newbie to macros and could use your experienced help.
1. I have a SS with a list of person names in colunm "A" which I want
to compare against a text-file list of names. If there is NO MATCH to
the text-file list, I want the persons name in column “A” to be copied
to the next column "B" starting at row one (1), to which the macro will
add an email extension such as "@server.com"
2. In my column "A" of the SS, the names look like;
john m doe
suzy q diamond
boss skaggs
good o boy
3. The text-file (filename: ./DOCS/email_list.txt) list of email
names looks like:
(e-mail address removed),
(e-mail address removed),
(e-mail address removed),
(e-mail address removed)
4. So, to me the first step is convert the names in "A" by replacing
the 'space' character, with the " ." (dot) character. In my basic VB
reading, this appears to need a For-Next-Loop.(but I don't know the
details of how to put this all together yet).
5. After the ‘space-to-dot’ conversion in step #4 above, I think I need
another "For-each loop to compare each new name in column "A" (i.e. the
john.m.doe) compare it with 'any' name in the "Text" file, but,
ignoring the @server.com etc.
5A. If “NOT a MATCH” in #5 above, copy the current "A" list name to
column "B",(beginning at row #1 of "B") and append to the name
"@server.com" (it is assumed that all individuals with have the same
email extension such as '@mcdonalds.com').
Thanks for any help you can provide to this newbie !
I am a newbie to macros and could use your experienced help.
1. I have a SS with a list of person names in colunm "A" which I want
to compare against a text-file list of names. If there is NO MATCH to
the text-file list, I want the persons name in column “A” to be copied
to the next column "B" starting at row one (1), to which the macro will
add an email extension such as "@server.com"
2. In my column "A" of the SS, the names look like;
john m doe
suzy q diamond
boss skaggs
good o boy
3. The text-file (filename: ./DOCS/email_list.txt) list of email
names looks like:
(e-mail address removed),
(e-mail address removed),
(e-mail address removed),
(e-mail address removed)
4. So, to me the first step is convert the names in "A" by replacing
the 'space' character, with the " ." (dot) character. In my basic VB
reading, this appears to need a For-Next-Loop.(but I don't know the
details of how to put this all together yet).
5. After the ‘space-to-dot’ conversion in step #4 above, I think I need
another "For-each loop to compare each new name in column "A" (i.e. the
john.m.doe) compare it with 'any' name in the "Text" file, but,
ignoring the @server.com etc.
5A. If “NOT a MATCH” in #5 above, copy the current "A" list name to
column "B",(beginning at row #1 of "B") and append to the name
"@server.com" (it is assumed that all individuals with have the same
email extension such as '@mcdonalds.com').
Thanks for any help you can provide to this newbie !