Results 1 to 1 of 1
2012-03-19, 12:29 #1
- Join Date
- Jan 2001
- Thanked 1 Time in 1 Post
Concatenate macro to make whole number and cap letter
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.