apgmin
Board Regular
- Joined
- Mar 1, 2010
- Messages
- 150
- Office Version
- 2013
- Platform
- Windows
Please help
A1 has the list has specialisation ( From a data validation list )
B1 has the semester no. ( 1 to 6)
Now from Cells c1 to j1 the values should change based on the value of cells a1 and b1
like if the specialisation is marketing Management and semester number is 1 cell c1 till cell j1 should get populated by the modules in semester1 for marketing management
IF the specialisations remains same but semester number changes to say 2 , then the cell c1 till cell j1 should get populated by the modules in semester2 for marketing management
Similarly for 10 other specialisations
The list of subjects are there in the same sheet in a table with the top row mentioning the specialisation and next row mentioning the semester no. this is followed by the list of subjects for that semester and specialisation
Example :
Marketing Management Marketing Management Operations Management Operations Management
1 2 1 2
subject 1a subject 2a subject 1f subject 2f
subject 1b and so on subject 2b and so on subject 1g and so on subject 2g and so on
A1 has the list has specialisation ( From a data validation list )
B1 has the semester no. ( 1 to 6)
Now from Cells c1 to j1 the values should change based on the value of cells a1 and b1
like if the specialisation is marketing Management and semester number is 1 cell c1 till cell j1 should get populated by the modules in semester1 for marketing management
IF the specialisations remains same but semester number changes to say 2 , then the cell c1 till cell j1 should get populated by the modules in semester2 for marketing management
Similarly for 10 other specialisations
The list of subjects are there in the same sheet in a table with the top row mentioning the specialisation and next row mentioning the semester no. this is followed by the list of subjects for that semester and specialisation
Example :
Marketing Management Marketing Management Operations Management Operations Management
1 2 1 2
subject 1a subject 2a subject 1f subject 2f
subject 1b and so on subject 2b and so on subject 1g and so on subject 2g and so on
