Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 97
  • Last Modified:

Mass Creation of mailboxes with excel (indirect)

Dear experts,

pls see the excel file attached. I'm building from data in worksheet "cas" in worksheet "admin-ps" the dataset for only one user. The powershell code will created below in "admin-ps". I'm using excel indirect to switch between the lines in worksheet CAS.
What i like is to build for all user are in CAS the powershell code without building a complete dataset and switch to every user.
Any idea how it could solve the best way?

Appreciate for your help
dataexample.xlsx
0
Mandy_
Asked:
Mandy_
1 Solution
 
QlemoC++ DeveloperCommented:
Am I'm correct that you don't want to touch CAS sheet?
The simplest way is to transform your admin-ps lines into columns. I've done that in the modified XLSX file.
dataexample.xlsx
0
 
Mandy_Author Commented:
I would like to express my sincere appreciation of  and heartfelt thanks to qlemo. Great work!
0

Featured Post

Who's Defending Your Organization from Threats?

Protecting against advanced threats requires an IT dream team – a well-oiled machine of people and solutions working together to defend your organization. Download our resource kit today to learn more about the tools you need to build you IT Dream Team!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now