How can I create a spreadsheet from different data sources?

Hi,

I am hoping what I am trying to do is even possible in Excel, but I know that if it is, you are the group to direct me.

I have three data sources: Project, Activity, Role:

Project
Project 1
Project 2

Activity
Activity 1
Activity 2
Activity 3

Role
Role 1
Role 2

All three data sources can change (contents and number), so I want to develop an automated way of producing the following spreadsheet from these data sources:

Role Project Activity
Role 1 Project 1 Activity 1
Role 1 Project 1 Activity 2
Role 1 Project 1 Activity 3
Role 2 Project 1 Activity 1
Role 2 Project 1 Activity 2
Role 2 Project 1 Activity 3
Role 1 Project 2 Activity 1
Role 1 Project 2 Activity 2
Role 1 Project 2 Activity 3
Role 2 Project 2 Activity 1
Role 2 Project 2 Activity 2
Role 2 Project 2 Activity 3


My thoughts are that this might be able to be done with a couple of DO loops, but I have limited experience in VBA and am not sure where to start. Can you help me?

Thank you!
Cheryl

Hi Cheryl
Firstly what format are the data sources you are using? For example are they MS Word documents?
Tony