Using Advanced Filter: How do you MOVE the selected rows...

R

ravif

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.
 
F

Fred Smith

There's no built in Move function, so just delete the selected rows after
the copy.

Regards,
Fred
 
R

ravif

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
 
F

Fred Smith

You're right. You just select the same rows you are copying (the visible
ones).

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting rows to another sheet 2
DREAM FEATURE: A macro that moves a row but asks me where to move it 18
auto filter on columns 2
Advanced filter 1
advanced filter a range 2
Macro to copy value in field and insert it into filter 2
missing data w/ advanced filter 6
Excel 2003 Macro - Finding rows with data to copy 1

Top