Hi All,
I am not a master in VBA Excel and I really stuck with a problem.
In nutshells:
Given a database like this:
Name Dep Grade
Person 1 1 Level 12
Person 2 1 Level 12
Person 3 2 Level 11
Person 4 2 Level 11
Person 5 2 Level 10
Person 6 3 Level 10
Person 7 4 Level 9
Person 8 4 Level 9
Person 9 4 Level 8
Person 10 4 Level 8
This list can be 220 rows long, but it depends on the organisation.
My Aim to arrange the values in the name column in a table like this:
1 2 3 4
Level 12
Level 11
Level 10
Level 9
Level 8
Since I know there's possibility of more cells with same level and department, I needed a table sheet with exact rows I manage to display as many rows for each levels as they have in the database (f.e. each level is at least 1 row, but if there are more cells than the actual count of the levels).
I tried with while and also with for but it always fails to how the cells in the correct rows and columns:
I really appreciate any ideas.
Thanks.
Bookmarks