Copying data to new sheets based on cell value

  • I have a data sheet where there is presented Name, personal number, email etc. I have around 500 Rows with person data, that needs the data separated in different sheets sorted after names. I have color coded the persons data and the sheets to where their data should go.

    I have made an vba that can make sheets with the given 500 names, but have no clue on how to copy the data to the right sheets based on the cell value with their names.



    here is the doc with the code i have so far.

    Kopi af Sletteanmodninger macro.xlsm

  • Delete all the personal name sheets so that only your data sheets remains and try this macro:

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • Delete all the personal name sheets so that only your data sheets remains and try this macro:

    Thanks for taking your time to do this ! was very helpfull!! and sorry for the late response, been out of town

  • This is some generic code that I wrote, it assumes the names are in Column A