I am putting together a list for a wedding. I have the main list with names and address on one worksheet. Now I need to copy the name and address and paste to another worksheet for sub lists. I made a column for each sub list and put an "x" in the cell of the names that are to be copied to the other sublists. Is there a way to write a macro so that it copies the names and pastes them on the correct sublist on a different worksheet.
thanksExample.xlsx
Bookmarks