L
Lee
I have one array with unit numbers (1-650) in A, size codes (a-i) in B, and
third col. for search result of size code.
Second array receives unit numbers of vacant units in A.
I have programming experience but limited excel . I think The subject
construct will do what I need. It will step thru the second array getting
the unit numbers and search the first array to find the unit and put the
resulting size code in the third col.
I then want to count the results to put totals of the various size codes in
respective cells.
The subjects example says For Each element In group. I assume element is
the col. name or letter and the group is the limits of the array. Is this
right?
Secondly, how do I start the VBA function?
Sorry to be so elementary but I haven't been able to find the answers.
third col. for search result of size code.
Second array receives unit numbers of vacant units in A.
I have programming experience but limited excel . I think The subject
construct will do what I need. It will step thru the second array getting
the unit numbers and search the first array to find the unit and put the
resulting size code in the third col.
I then want to count the results to put totals of the various size codes in
respective cells.
The subjects example says For Each element In group. I assume element is
the col. name or letter and the group is the limits of the array. Is this
right?
Secondly, how do I start the VBA function?
Sorry to be so elementary but I haven't been able to find the answers.