How do I filter results to copy to another sheet and allowing modifications?

Hey everyone,

Ok so I have a pretty large set of data. Each row represents each person in the database. The columns range from First, Last, DOB, DL # and so on. What I need to do is be able to have excel pull everyone who has an (x) in one column denoting their attendance or not into a new sheet. The thing is that I do not want it to just pull thier name. I want it to pull the whole row of infomration if the one column has an x. I do not want to use auto filter, because I want it to export to another sheet and leave the raw data behind. Also I want to be able to add and remove people from the master list, and if I add them with an x, I want them to be added to the other new sheet. Please help!

Thanks!

Hi,

Please take some time to familiarise yourself with the forum rules and edit your thread title accordingly.

Dom

Have a look at the attached example. If you pop an x in column C it will copy the row(s) to Sheet2.

Dom