You mention “paste” sheet which indicates that this is something you copy and paste from ____________?, it may be better to have an additional column with the zone there and simply filter. More explanation_______? What you want can be done using FINDNEXT.
Don Guillett SalesAid Software dguille...@gmail.com From: Jason Henke Sent: Thursday, February 23, 2012 6:51 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ If data is on list sheet move row to correct zone Attached is a sample bit of data I'm trying to automatically move rows based on their location in column A on the 'Paste Sheet'. If it matches a Zone list on the 'Location' sheet I'd like it to move there. Also in the location sheet I have a Delete column, I have the macro together to delete matches that works great (also included) This is a bit of sample data and not the full list of locations we have, just hoping to save myself a bit of time when running the report by moving the data where I need it. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com