Thread: Creating a software list for AD

Hi

Im not sure the best way to go about this but what I want to do is on sheet one enter a list of software required then via a vlookup find out the AD group this part is not a issue but what I want to do is put all the AD groups in to some sort of concatenate line which can be copied and pasted in to AD. As the list could have little as 1 application or many as 50 may be script would be the best way?

e.g. AD-MS_Word_2003; AD-MS_Excel_2003


Sheet 1 = Required_Software (User enters the required software on this page)
(This has not displayed right there should be 2 columns, 1 - Software name , 2 - Active Directory )
Software name Active Directory Name
MS Word 2003 AD-MS_Word_2003
MS Excel 2003 AD-MS_Excel_2003


Sheet 2 = Software (This sheet has a large list of software available)

Software name Active Directory Name
MS Access 2003 AD-MS_Access_2003
MS Word 2003 AD-MS_Word_2003
MS Excel 2003 AD-MS_Excel_2003
MS Outlook 2003 AD-MS_Outlook_2003
MS PowerPoint 2003 AD-MS_PowerPoint_2003