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.