Copying X amount of names from list and enter in another column

  • Re: Copying X amount of names from list and enter in another column


    Hi
    Paste the code below into the module named Test in the VB editor & have a play. I think it's what you're after
    Cheers

  • Re: Copying X amount of names from list and enter in another column


    Wow....... Just tested it....... That is exactly what I needed, I had started using Vlookup formulas etc but this is much better. I should be able to use this in other applications to. Thank You :thumbcoo:

  • Re: Copying X amount of names from list and enter in another column


    Ah, just found a hiccup...... In B2 determines the comp sheet I would use in the example 32.... If the player number is over 29 the col J is wrong as in the example below.......... everything else is fine... Easy fix?



    [ATTACH=CONFIG]68760[/ATTACH]

  • Re: Copying X amount of names from list and enter in another column


    I had a "Play" & using the case function I used 3 different cases,
    1. For full sheet of players (eg 32), removed last line of code
    2. For full <1 (eg sheet 32, 32 players), removed +1 from last line of code
    3 for the rest.
    Probably a bit messy but it works!! Thanks again

Participate now!

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