PDA

View Full Version : 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.

Bob Phillips
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!