Run macro for every next row with value and use the value in the macro

  • Hi,

    I have a workbook with 3 sheets:
    - Lista - a sheet with the list of names in column A and with a button ("Wypełnij_zbiorówkę" macro assigned to the button)
    - Szablon (hidden) - a template used by "UtworzSzablon2" macro
    - Zbiorówka - the master sheet; data from "Szablon" are put there after running "Wprowadź_klinięcie2" macro

    I would like "Wypełnij_zbiorówkę" macro to start with Lista!A1 and move down the list as long as there are values (names). I also need those values (names) to be put in Szablon!C2 cell.

    This is what I got so far:

    The code works but only for Lista!A1 cell. I have no idea how to make this macro move down to A2, A3 and so on.

    Any ideas, anyone? Please help

Participate now!

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