Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a form for multiple users | Excel Worksheet Functions | |||
VBA script help..Please !!!! | Excel Discussion (Misc queries) | |||
VB script help..please !! | Excel Worksheet Functions | |||
prevent users from overwriting other users data | Excel Worksheet Functions | |||
Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions |