Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter cut and paste
I am trying to autofilter the AI column and then cut the results and
send them to another file. Does anyone have any idea how to do this? Thanks for your help, Peter |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter cut and paste
Start out by turning the macro recorder on and performing the action
manually. Turn off the macro recorder and look at the recorded code. Modify it to suit your needs. -- Regards, Tom Ogilvy "Peter" wrote: I am trying to autofilter the AI column and then cut the results and send them to another file. Does anyone have any idea how to do this? Thanks for your help, Peter |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter cut and paste
On 28 Feb, 14:33, Tom Ogilvy
wrote: Start out by turning the macro recorder on and performing the action manually. Turn off the macro recorder and look at the recorded code. Modify it to suit your needs. -- Regards, Tom Ogilvy "Peter" wrote: I am trying to autofilter the AI column and then cut the results and send them to another file. Does anyone have any idea how to do this? Thanks for your help, Peter- Hide quoted text - - Show quoted text - Hi Tom, When I cut the filtered selection, it also cuts the non-filtered rows, any ideas? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter cut and paste
I have never come across a way to cut from a filtered list you can I believe
only copy "Peter" wrote: On 28 Feb, 14:33, Tom Ogilvy wrote: Start out by turning the macro recorder on and performing the action manually. Turn off the macro recorder and look at the recorded code. Modify it to suit your needs. -- Regards, Tom Ogilvy "Peter" wrote: I am trying to autofilter the AI column and then cut the results and send them to another file. Does anyone have any idea how to do this? Thanks for your help, Peter- Hide quoted text - - Show quoted text - Hi Tom, When I cut the filtered selection, it also cuts the non-filtered rows, any ideas? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter cut and paste
How about doing a copy|paste, then come back and do a delete (don't delete the
header!). Peter wrote: On 28 Feb, 14:33, Tom Ogilvy wrote: Start out by turning the macro recorder on and performing the action manually. Turn off the macro recorder and look at the recorded code. Modify it to suit your needs. -- Regards, Tom Ogilvy "Peter" wrote: I am trying to autofilter the AI column and then cut the results and send them to another file. Does anyone have any idea how to do this? Thanks for your help, Peter- Hide quoted text - - Show quoted text - Hi Tom, When I cut the filtered selection, it also cuts the non-filtered rows, any ideas? -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter cut and paste
I rarely cut on a sheet anyway. I copy to another location, then come back
and delete. That should work in this situation. -- Regards, Tom Ogilvy "Peter" wrote: On 28 Feb, 14:33, Tom Ogilvy wrote: Start out by turning the macro recorder on and performing the action manually. Turn off the macro recorder and look at the recorded code. Modify it to suit your needs. -- Regards, Tom Ogilvy "Peter" wrote: I am trying to autofilter the AI column and then cut the results and send them to another file. Does anyone have any idea how to do this? Thanks for your help, Peter- Hide quoted text - - Show quoted text - Hi Tom, When I cut the filtered selection, it also cuts the non-filtered rows, any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste into autofilter selection! | Excel Worksheet Functions | |||
Autofilter - copy & paste | Excel Worksheet Functions | |||
Copy/Paste in Autofilter | Excel Discussion (Misc queries) | |||
Autofilter and Copy and Paste | Excel Programming | |||
AUTOFILTER copy and paste | Excel Programming |