Results 1 to 1 of 1
  1. #1
    4 Star Lounger
    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.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts