Hi all,
I am a beginner in VBA.
In the example attached ( there are an unspecified number of codes and groups)
I need:
1. how to collect the codes belonging to a given group into an array or arrays, but into a range or ranges .
2. make columns for the groups in the new sheets created
3 . I need to assign a macro to the button "Check Checkboxes for Group" that will check the checkboxes in column A for a given group, as well as the possibility of selecting the group after entering in the InputBox
It seems to me that I need for point 1. an option to an array or arrays, because if I need to in new sheets columns for groups, I would like that within the workbook the group membership of the codes is remembered
Regards
I am a beginner in VBA.
In the example attached ( there are an unspecified number of codes and groups)
I need:
1. how to collect the codes belonging to a given group into an array or arrays, but into a range or ranges .
2. make columns for the groups in the new sheets created
3 . I need to assign a macro to the button "Check Checkboxes for Group" that will check the checkboxes in column A for a given group, as well as the possibility of selecting the group after entering in the InputBox
It seems to me that I need for point 1. an option to an array or arrays, because if I need to in new sheets columns for groups, I would like that within the workbook the group membership of the codes is remembered
Regards