Fill Blanks in List

    Re: Vb Copy The Content Of Upper Cells


    just select the cells followed by

    Re: Vb Copy The Content Of Upper Cells


    sorry, i didnt finish


    How to copy content of upper cell by looking first 6 characters (numbers)


    example


    000012 ZLAVAL D.O.O.
    000012 ZLAVAL D.O.O.
    000012 ZLAVAL D..O.
    000027 SEMIK-PROMET D.O.O.
    000027 SEMIKPROMET D.O.O.
    000027 SEMIK-PROMET D.O.O.
    000027 SEMIK-PROMET D.O.
    000027 SEMIK-PROMET D.O.O.
    000066 K.T.C.SISAK TRG.41
    000066 K.T.C.SISAK TRG.4


    if you see first 6 Number are the same but there is difference in other characters,some characters are missing,to long time to autofill because there is 19800 rows
    When you put that in PivotTable you get seperate data, the whole cells must bee the same
    This is in some case Similarly to VB FillBlankCells

    Re: Vb Copy The Content Of Upper Cells


    Dperic/Twister001


    We do not permit using multiple usernames to avoid a temporary ban. Your usernames will be merged, if you continue to sign on as different names you will be permanently banned.


    Follow the instructions Here

Participate now!

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

Register Yourself Login