LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Need help in creating a Script for Users

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a form for multiple users Data Coordinator Excel Worksheet Functions 1 November 8th 06 04:09 PM
VBA script help..Please !!!! Anthony Excel Discussion (Misc queries) 6 June 6th 05 01:40 PM
VB script help..please !! Anthony Excel Worksheet Functions 2 June 5th 05 03:26 PM
prevent users from overwriting other users data [email protected] Excel Worksheet Functions 0 April 17th 05 08:18 PM
Help - Automating a file.. Adding Users , Deleting users, Changing Tim Harding Excel Worksheet Functions 0 March 16th 05 01:25 PM


All times are GMT +1. The time now is 04:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"