| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Move rows to another worksheet with vba
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. In my excel file in "MoveRows" in the Open worksheet the value or rather the name to be search 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.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move rows to another worksheet | Excel Discussion (Misc queries) | |||
| Sort rows and move borders with rows | New Users to Excel | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| How do I select all the even rows in a worksheet and move them. | Excel Discussion (Misc queries) | |||
| How do I move up rows below blank rows in an address? | Excel Worksheet Functions | |||
Threaded Mode
