Nishu
I am still unsure of your exact requirements, so I will propose two solutions:
1) You want column B blanked (text and background is the same colour), and when you enter the name in column A in the correct row, the same row's column B text changes colour. This is quite tricky, and not very useful. But if this is what you want, please let us know.
2) You have, somewhere in the workbook, say on a separate sheet, columns A and B populated as you described below.
On your first sheet, enter a name in column A, and use a vlookup formula in column B to display the userID. E.g. B2=vlookup(A2,'Sheet2'$A$2:$B$5000,2,false). Note the use of locked lookup range, and when you copy the formula down to cell B3, cell B3 will look for cell A3's text in the lookup table.
You may also consider defining Sheet2 Column A as a named range called "EmpNames", and then Sheet1 Column A use data validation, List, =EmpNames to ensure no typographical errors spoil your day.
Lastly, you should also research vlookup and data validation to ensure you implement this correctly.
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf Of Nishu Kumar
Sent: Friday, 17 February 2012 6:05 AM
To: excelvba@yahoogroups.com
Subject: Fw: [ExcelVBA] enable event
Please accept my sincere apologies as i was not able enough to explain
my query. Please find attached sheet where column A consist associate
name and column b consist their unique system id (provided by the
organization). All i want is the coding/procedure/name of the variable,
event name etc. which help me to populate the system id automatically in
the column b assuming that column b is blanked and i am mentioning the
associate name in column A one by one.
columnAcolumnB
Associate Name SysId
Jhony asdf
addison hgdd
denisson reww
shreya juhgt
rikky gtfdd
shaurya njjja
tom cdfg
harry ujghrt
shona jttfj
Kindly assist on this.
Thanks & Regards,
Nishu
----- Forwarded Message -----
From: "david.smart@ubs.com <mailto:david.smart%40ubs.com> " <david.smart@ubs.com <mailto:david.smart%40ubs.com> >
To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
Sent: Thursday, 16 February 2012 6:59 AM
Subject: RE: [ExcelVBA] enable event
The Yahoo Group has automatically stripped off your attachment. You
need to explain in your e-mail or upload a file to the files area.
Regards, Dave S
________________________________
From: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com> [mailto:ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com> ] On
Behalf Of Nishu Kumar
Sent: Wednesday, 15 February 2012 10:22
To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
Subject: Re: [ExcelVBA] enable event
Hi sir,
Please accept my sincere apologies as i was not able enough to explain
my query. Please find attached sheet where column A consist associate
name and column b consist their unique system id (provided by the
organization). All i want is the coding/procedure/name of the variable,
event name etc. which help me to populate the system id automatically in
the column b assuming that column b is blanked and i am mentioning the
associate name in column A one by one.
Kindly assist on this.
Thanks & Regards,
Nishu
________________________________
From: Paul Vermeulen <paul.vermeulen@vulcantech.com.au <mailto:paul.vermeulen%40vulcantech.com.au>
<mailto:paul.vermeulen%40vulcantech.com.au> >
To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com> <mailto:ExcelVBA%40yahoogroups.com>
Sent: Tuesday, 14 February 2012 8:59 AM
Subject: RE: [ExcelVBA] enable event
Nishu
You are not describing the problem clearly enough for someone to give
you guidance on how to solve it yourself. How exactly to you want to
generate the unique employee id? Assuming you type in a name and first
letter of surname in column a, do you want random characters as a
suffix? Do you want sequential characters as a suffix? How about
starting with numeric rather than text characters? Let us know, please.
From: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com> <mailto:ExcelVBA%40yahoogroups.com>
[mailto:ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com> <mailto:ExcelVBA%40yahoogroups.com> ]
On
Behalf Of Nishu Kumar
Sent: Tuesday, 14 February 2012 8:04 AM
To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com> <mailto:ExcelVBA%40yahoogroups.com>
Subject: [ExcelVBA] enable event
Hi Group,
How you doing!!
Hope this mail finds you doing well.
I am trying to enable a column b in excel with unique employee ids.
please suggest me the coding as what needs to be done to get the
respective team member ids get populated when name mention in column a.
e.g.
column Acolumn b
johnyasdfi (should come automatically, when i mention the name in column
A)
danissonijklm (should come automatically, when i mention the name in
column A)
Kindly suggest.
Thanks & Regards,
Nishu
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
----------
Visit our website at http://www.ubs.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.
UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[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