ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Wedding List (https://www.excelbanter.com/excel-discussion-misc-queries/208063-wedding-list.html)

John

Wedding List
 
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

Wedding List
 
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?





All times are GMT +1. The time now is 08:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com