I am trying to create a macro to accomplish the following:

You have a list of x amount of rows of data. I want you to be able to put an X into A(whatever) and then click a button. At that point it will take all of the rows with an X in it and copy them onto a new sheet called Details. It would be really great to be able to have it be a nice check-mark box but I don’t know how one would do that if you don’t know how may rows the original list will be.

Thank you in advance.