oliverraaijmakers
New Member
- Joined
- Jun 25, 2012
- Messages
- 3
Hello there,
I am trying to create a (macro) worklist-generator, which should create a list of activities for every deliverable that needs to be done.
The input "deliverable" is a list of numbers which can vary from 1 cell value, up to 50 (in the same column, below eachother). An empty cell indicates the end of the list.
The input "activities" is a list of teksts which can vary from 1 cell value, up to 25 (in the same column, below eachother). An empty cell indicates the end of the list.
The output should be a list of two columns (deliverable and activity), with all combinations of deliverables and activities listed below eachother.
Can anyone help me with a macro that can do this?
I am trying to create a (macro) worklist-generator, which should create a list of activities for every deliverable that needs to be done.
The input "deliverable" is a list of numbers which can vary from 1 cell value, up to 50 (in the same column, below eachother). An empty cell indicates the end of the list.
The input "activities" is a list of teksts which can vary from 1 cell value, up to 25 (in the same column, below eachother). An empty cell indicates the end of the list.
The output should be a list of two columns (deliverable and activity), with all combinations of deliverables and activities listed below eachother.
Can anyone help me with a macro that can do this?