Autofilter on the x's that you have in the specific column then copy and
paste the visible data to a new location to give you the list you want.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"John" wrote in message
...
I have a master worksheet. When I put an "x" in a specific column, I would
like that informaiton to transfer over to a seperate worksheet. I am
trying
to get a seperate list for showers and making sure that everything is
seperate. Can anyone make any suggestions?