| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Advanced Filter: How do you MOVE the selected rows...
I can copy the selected rows to another location, but is there a way to move
the selected rows, so that the original sheet has only the unselected rows? I don't mind using VBA to program the modified behavior, if the Advanced Filter has a documented programmable interface. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Advanced Filter: How do you MOVE the selected rows...
There's no built in Move function, so just delete the selected rows after
the copy. Regards, Fred "ravif" wrote in message ... I can copy the selected rows to another location, but is there a way to move the selected rows, so that the original sheet has only the unselected rows? I don't mind using VBA to program the modified behavior, if the Advanced Filter has a documented programmable interface. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Advanced Filter: How do you MOVE the selected rows...
Fred,
Thanks for your reply, and I think before I delete, I have to choose the visible rows, as given in a previous post. Thanks again. --ravif "Fred Smith" wrote: There's no built in Move function, so just delete the selected rows after the copy. Regards, Fred "ravif" wrote in message ... I can copy the selected rows to another location, but is there a way to move the selected rows, so that the original sheet has only the unselected rows? I don't mind using VBA to program the modified behavior, if the Advanced Filter has a documented programmable interface. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Advanced Filter: How do you MOVE the selected rows...
You're right. You just select the same rows you are copying (the visible
ones). Regards, Fred. "ravif" wrote in message ... Fred, Thanks for your reply, and I think before I delete, I have to choose the visible rows, as given in a previous post. Thanks again. --ravif "Fred Smith" wrote: There's no built in Move function, so just delete the selected rows after the copy. Regards, Fred "ravif" wrote in message ... I can copy the selected rows to another location, but is there a way to move the selected rows, so that the original sheet has only the unselected rows? I don't mind using VBA to program the modified behavior, if the Advanced Filter has a documented programmable interface. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced Filter for blank fields in multiple rows | Excel Discussion (Misc queries) | |||
| Advanced Filter - filter rows < | Excel Discussion (Misc queries) | |||
| Use Advanced Filter to Detect non blank rows | Excel Discussion (Misc queries) | |||
| No. of rows selected from auto filter not visible on toolbar? | Excel Discussion (Misc queries) | |||
| Is de-duping in advanced filter limited to a number of rows | Excel Worksheet Functions | |||
Hybrid Mode
