cut filtered-selected rows from a sheet1 then paste in another sheet2

drtopserv
drtopserv used Ask the Experts™
on
Hi,
I have sheet1 with columns and rows, and did a filter in column A (select first row middle one and last row), when i come and cut these selected rows and paste them in sheet2 , it paste me them. but in sheet1 all the other unselected row vanished.
 
i need to fix this problem by using vba i need to using this cut into a macro.
thnx in regard.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Russ SuterSenior Software Developer

Commented:
Use Copy and Paste instead of Cut and Paste then the rows will remain in Sheet1 also.
Rob HensonFinance Analyst

Commented:
If you then want to get rid of the filtered rows (and only the filtered rows) deleting the rows while filtered will only delete the visible rows.

Thanks
Rob H
Partner
Commented:
Is this what your looking for ?
Just make sure your macroes are activated and filter this sample file in Sheet1 under any column or combination and activate the button Transfer to Sheet2 and check the results in Sheet2 and then remove the filtering in sheet1 and also check it.

Let me know if it answers your question.
gowflow
TransferFilteredRows.xls
drtopserv

Author

Commented:
Perfect0!!
thanx alot thats what i want exactly :]
gowflowPartner

Commented:
Your welcome my pleasure glad I could help you.
gowflow

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial