Copying data from an existing sheet to exist with data outside excel

[mschomisch1030]

I hope my title isn't confusing. I'll try to make this concise and not ramble. This is kind of a two part question.

I had posted last week about trying to come up with a way to copy a selection of data from a worksheet to go on a new worksheet if an "X" was marked in the row under a certain heading.

It worked perfectly.

Now, after looking at it and showing associates, we feel it needs more information. In addition to the data that is copied, I want to be able to have additional information.

I have the Excel sheet provided, and as you can see, the code is in place and you can see what is copied from 'Master Listing (KA)' to 'HSDP'. You can also see that there are two headings which don't have any data in them. These two pieces are coming from an enrollment list elsewhere within an entirely new workbook.

*Part 1 question: There are participants that are within the HSDP that don't come from the Master Listing. Is there a way that once I run this code and add in the two remaining columns, that I can just type in new names to this list? The Master Listing changes so that means there could be new names added, and then by running the code it would erase names that have been typed in along with making things out of place because of the two columns being typed in as well. It might just make sense to add those two columns to the Master. But then I'd still be potentially erasing things with the typed in names and running the code. Two lists on the sheet?

- The Heading marked dual enrollment is probably an easy fix. If columns 'I' and 'M' both have a check then that means they are dual enrolled.


*Part 2 question: Would you recommend I just manually type and copy in the lists to the sheets? Ultimately, it probably wouldn't take very long and I could add in simple IF formulas to count the dual enrollment. Ideally though, I want Excel to do the busy work for me so I can spend it meeting with these people.

Sorry if I rambled. Thanks for all the help. I REALLY appreciate it. This website is amazing.