| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut and Paste macro based on criteria then delete empty rows
Hi All,
First time poster and VBA bewbie. Any help would be great!! I'm using ecxel 2000 Here's my problem: I have a worksheet (Sheet1) from which I need to cut paste any row (in the Range A3:AD300) where column "O" has a certain value in it into Sheet2. I'd like the pasting to begin in the first blank row of Sheet2. Then I'd like the blank rows of Sheet1 to be deleted. Is this possible? Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Rows based on criteria in excel | Excel Discussion (Misc queries) | |||
| How can I delete rows programmatically based on certain criteria? | New Users to Excel | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| Delete rows based on criteria | Excel Discussion (Misc queries) | |||
| Delete rows based on certain criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
