Need Excel Macro

[Anuj]

I Need a excel macro through which we check the users login on a list of
machines.
If we run a macro the script find the corresponding user of the machines
from one column, and writes the Login Id in the next column.
Any help please, not sure if this is the right group.

 

[Joel]

Need more description of your data. Details f wher the User Login comes from
and wehre the list of machines comes from.

 

[Anuj]

it should be designed in a way that we populate the list of machines in
column A, and if we run the macro user id gets displayed in column B.

not sure from where the user id will come, may be through some command, not
sure.

 

[Joel]

I don't know if the USERNAME on the local PC is the same name you are looking
for. Can get user ID with this code

UserName = Environ("USERNAME")
MsgBox (UserName)

It sounds like the same user will have a different UserName on different
machines? It seems that you need to look up the persons name to get the ID.


Is your data like this

Server1 Jdoe
Server1 mSmith
server2 badam
server2 cdown
Server2 mSmith


And you want the results like this

jDoe Server1
mSmith Server1 Server2
badam Server2
cdown Server2