Hi!

I have this routinary task that I really want to speed up. We usually have
users coming in at around every 2 weeks. The HR department gives us a list of
users in an Excel Sheet arranged like this:

Column 1 Column 2 Column 3
Username First Name Last Name

We usually follow a template for this said accounts so I usually end up
copying around 20 accounts for every batch that the HR sends us.

Can someone please teach me how to create a script so that I it fetches the
columns for their corresponding tabs? Like Username is for Username First
Name is for first name, Last name, etc. and with an addition of Display Name,
Description, Password (we give them the default password first), and the
default groups in accordance with the template account.

Thanks!

Can anyone please help me?
thanks!

"ShadowoftheDarkgod" wrote:

Hi!

I have this routinary task that I really want to speed up. We usually have
users coming in at around every 2 weeks. The HR department gives us a list of
users in an Excel Sheet arranged like this:

Column 1 Column 2 Column 3
Username First Name Last Name

We usually follow a template for this said accounts so I usually end up
copying around 20 accounts for every batch that the HR sends us.

Can someone please teach me how to create a script so that I it fetches the
columns for their corresponding tabs? Like Username is for Username First
Name is for first name, Last name, etc. and with an addition of Display Name,
Description, Password (we give them the default password first), and the
default groups in accordance with the template account.

Thanks!

If you're trying to retrieve values based on a common key (but a unique key),
you may be able to use =vlookup() or =index(match()).

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) he
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

(But I'm not sure what you're doing.)

ShadowoftheDarkgod wrote:

Hi!

I have this routinary task that I really want to speed up. We usually have
users coming in at around every 2 weeks. The HR department gives us a list of
users in an Excel Sheet arranged like this:

Column 1 Column 2 Column 3
Username First Name Last Name

We usually follow a template for this said accounts so I usually end up
copying around 20 accounts for every batch that the HR sends us.

Can someone please teach me how to create a script so that I it fetches the
columns for their corresponding tabs? Like Username is for Username First
Name is for first name, Last name, etc. and with an addition of Display Name,
Description, Password (we give them the default password first), and the
default groups in accordance with the template account.

Thanks!

--

Dave Peterson

Thanks for the reply!

Well, what I have is this:

First column Second column Third column Fourth Column
5th

Logon Name First Name Last Name Groups Membership
Password


What I need is a script that will fetch all of the data, (let's say users 1
to 20) so I can just run a script then have the users created instantly.

Thanks!

Did the =vlookup() or =index(match()) solution work for you when you tried it?

If it did, then maybe it could be automated. If it didn't, then I think more
info is required.

ShadowoftheDarkgod wrote:

Thanks for the reply!

Well, what I have is this:

First column Second column Third column Fourth Column
5th

Logon Name First Name Last Name Groups Membership
Password

What I need is a script that will fetch all of the data, (let's say users 1
to 20) so I can just run a script then have the users created instantly.

Thanks!

--

Dave Peterson