Wedding List

[John]

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?

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk