Hello all
I'm very very new to VBA. I checked internet forums to find a similar case and tried to modify the program as per my needs but I'm not satisfied with my work. I need your support to do this.
My case:
I have a matrix 21 rows * 30 columns with drop-down list on all the cells, user needs to compare and rank the row vs column (0-3 ranks)
I want to collect the rankings from multiple users (n numbers) and the average of each cells needs to be displayed on the main matrix sheet.
I created a start page where user needs to enter their name and a new worksheet with matrix on their name will be created.
My need:
I have a problem in collecting the average from each of the worksheets (even newly added) to be updated on the main matrix sheet. I don't want to show all the worksheets to each user, they are allowed to see and work only their worksheets.
Can someone help me to achieve this?
I'm very very new to VBA. I checked internet forums to find a similar case and tried to modify the program as per my needs but I'm not satisfied with my work. I need your support to do this.
My case:
I have a matrix 21 rows * 30 columns with drop-down list on all the cells, user needs to compare and rank the row vs column (0-3 ranks)
I want to collect the rankings from multiple users (n numbers) and the average of each cells needs to be displayed on the main matrix sheet.
I created a start page where user needs to enter their name and a new worksheet with matrix on their name will be created.
My need:
I have a problem in collecting the average from each of the worksheets (even newly added) to be updated on the main matrix sheet. I don't want to show all the worksheets to each user, they are allowed to see and work only their worksheets.
Can someone help me to achieve this?
