Hello – I need to iterate through a range of cells – B5:P24 and compare them to B30:B48. If B5 matches B30 then any capital letters in columns C to P, row 30 need to be concatenated with the number in row 5.
For example, B5 matches B30 (Male). So the macro searches all the columns in C30:P30 looking for capital letters. Since D30 has a cap “J” it needs to be added to the 49.5% in row 5. So D5 should be 50% J (roundup the 49.5%). N5 should be 52% A, P5 should be 62% AB. Do for all rows 5 to 24.
Thank you for the help.
