Loop with Criteria overwriting Data

  • I'm very interested in VBA Loops but have come up against a small but annoying problem.

    I'm Basically looping a range on sheet 2 for non blanks then moving the non blanks to sheet 1.

    The issue is the range between the 2 sheets are different (Much less non blanks than blanks)

    On sheet 1 I have multiple ranges and they overwrite the range below as the code is using the full range in sheet 2

    So that said sheet 2 loop i = 3 to 54 But for sheet 1 I just want to use 3 to 23 ..... Code below

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!