move cell to another sheet based on cell value

**patchypich** · 10-23-2011, 07:24 AM

hello,

I am a new member to this site and found it very useful. However I have been searching the forums and trying to learn how to edit these codes all weekend. I have a worksheet that needs to be sorted then moved to another sheet based on a value. I've tried serveral codes on this site but none seems to work. I have 200+ books that I need to sort and moved. The value is from column F. For every unique item I have to put that into a seperate sheet with like items.

attached is a sample. Its an autocad points ifle. I have to seperate each point based on what type of object it is. Once the sheet is created i have to save sheet as a comma delimited text so I can import it into autocad.

**watersev** · 10-23-2011, 09:28 AM

hi, patchypich, if I understood everything right, the end result required is the list of csv-files containing all rows with the unique object (column F). If it is correct, please save attachment file into an empty folder, open the file and run code "test". Check the folder for created csv-files.

**patchypich** · 10-23-2011, 10:06 AM

Watersev,

thanks for the quick replay. This was exactly what I need and more. You are amazing. This will save me ALOT of time. Thank you so much.

**patchypich** · 10-23-2011, 10:12 AM

Watersev,

I've tried putting the code into my other workbooks but it doesn't work. Is there something I am missing?

**patchypich** · 10-23-2011, 10:13 AM

Nevermind I figured it out! lol. Thanks again.

**watersev** · 10-23-2011, 10:40 AM

if you are happy with the help provided, please mark the thread as Solved:
Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.