I'd like to create a spreadsheet whereby the data is populated by pulling in data from Active Directory. The sort of information I'm after is things like the User's Name, Department, Telephone Number or Office Address perhaps ...all direct from the fields in AD.

I'm thinking that perhaps I create a command button to run whatever VBA I need and it populates the fields from there, ie it's updated everytime you click it.

Is this possible or should I find a different approach?

Many thanks all.

Brelin