move rows to another worksheet

**cwm7102** · 04-02-2012, 03:18 AM

I need help to find a value or name in a column and move all rows containing that value to another worksheet. It will be good if there's an input box to key in the value to search. I have attached my excel file & in Open worksheet the value or rather the name to find is in column D titled Person. I would like to find all rows with say John in Col D and move it to the next blank row ie row7 in Closed worksheet.

**xld** · 04-02-2012, 04:01 AM

Cross-posted (and already answered) at ExcelGuru http://www.excelguru.ca/forums/showthread.php?818-Move-rows-to-another-worksheet!

**Aussiebear** · 04-02-2012, 04:46 PM

and well answered at excelguru.ca too!

04-02-2012, 04:01 AM	#2
xld Distinguished Lord of VBAX VBAX Expert Joined: Apr 2005 Posts: 23,118 Kb Entries: 3 Articles: 2	Cross-posted (and already answered) at ExcelGuru http://www.excelguru.ca/forums/showthread.php?818-Move-rows-to-another-worksheet! ____________________________________________ Nihil simul inventum est et perfectum Abusus non tollit usum Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen! James Thurber
Local Time: 01:05 AM Local Date: 05-23-2013 Location:

04-02-2012, 04:46 PM	#3
Aussiebear Moderator VBAX Regular Joined: Dec 2005 Posts: 2,763 Kb Entries: 0 Articles: 0	and well answered at excelguru.ca too! Remember To Do the Following.... Use the VBA button to correctly submit your code to the forum. Mark your thread as Solved if satisfied by using the Thread Tools options
Local Time: 10:05 AM Local Date: 05-23-2013 Location: