Create new columns based on a list with names

  • Hi.
    I wanna ask you about a suggestion regarding the creating of new column (or columns) in a sheet. The name of the new column are the value of a range of cells (range "A:A" dynamic list in my example).
    Each cell value become a column header.
    After that a macro will be called for create dynamic list.
    You have an test example.
    In my example I've already created 7 columns.
    The new code will be able to create others columns (colored in red).
    For the future I will add new entries in dynamic range "A:A"
    Thank you.


    PS: sorry for my English

  • Re: Create new columns based on a list with names


    try below code:


Participate now!

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