Hanumantharayappa Y H
New Member
In range G14 you have an example of the table I want.
' Note that the macro should work without any change in the VBA Code if there is more or less than 31 project and if there is
' more or less than 3 different benefits and complexity.
'
' You have to write below the VBA code to do this.
Results should appear like this.
Example of result of the macro
Benefit/CompexityEasyMediumDifficult
HighProject_1 Project_15 Project_23Project_2 Project_3 Project_11 Project_2 Project_3 Project_11Project_5 Project_24 Project_29
MediumProject_4 Project_9 Project_14 Project_19 Project_28Project_16 Project_17 Project_16 Project_17Project_6 Project_12 Project_13 Project_18 Project_21 Project_22 Project_31
LowProject_7 Project_8 Project_10 Project_30Project_20 Project_26 Project_27 Project_20 Project_26 Project_27Project_25
Data:
Project NameBenefitComplexity
Project_1HighEasy
Project_2HighMedium
Project_3HighMedium
Project_4MediumEasy
Project_5HighDifficult
Project_6MediumDifficult
Project_7LowEasy
Project_8LowEasy
Project_9MediumEasy
Project_10LowEasy
Project_11HighMedium
Project_12MediumDifficult
Project_13MediumDifficult
Project_14MediumEasy
Project_15HighEasy
Project_16MediumMedium
Project_17MediumMedium
Project_18MediumDifficult
Project_19MediumEasy
Project_20LowMedium
Project_21MediumDifficult
Project_22MediumDifficult
Project_23HighEasy
Project_24HighDifficult
Project_25LowDifficult
Project_26LowMedium
Project_27LowMedium
Project_28MediumEasy
Project_29HighDifficult
Project_30LowEasy
Project_31MediumDifficult
' Note that the macro should work without any change in the VBA Code if there is more or less than 31 project and if there is
' more or less than 3 different benefits and complexity.
'
' You have to write below the VBA code to do this.
Results should appear like this.
Example of result of the macro
Benefit/CompexityEasyMediumDifficult
HighProject_1 Project_15 Project_23Project_2 Project_3 Project_11 Project_2 Project_3 Project_11Project_5 Project_24 Project_29
MediumProject_4 Project_9 Project_14 Project_19 Project_28Project_16 Project_17 Project_16 Project_17Project_6 Project_12 Project_13 Project_18 Project_21 Project_22 Project_31
LowProject_7 Project_8 Project_10 Project_30Project_20 Project_26 Project_27 Project_20 Project_26 Project_27Project_25
Data:
Project NameBenefitComplexity
Project_1HighEasy
Project_2HighMedium
Project_3HighMedium
Project_4MediumEasy
Project_5HighDifficult
Project_6MediumDifficult
Project_7LowEasy
Project_8LowEasy
Project_9MediumEasy
Project_10LowEasy
Project_11HighMedium
Project_12MediumDifficult
Project_13MediumDifficult
Project_14MediumEasy
Project_15HighEasy
Project_16MediumMedium
Project_17MediumMedium
Project_18MediumDifficult
Project_19MediumEasy
Project_20LowMedium
Project_21MediumDifficult
Project_22MediumDifficult
Project_23HighEasy
Project_24HighDifficult
Project_25LowDifficult
Project_26LowMedium
Project_27LowMedium
Project_28MediumEasy
Project_29HighDifficult
Project_30LowEasy
Project_31MediumDifficult