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

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.
drtopservAsked:
Who is Participating?
 
gowflowConnect With a Mentor 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
0
 
Russ SuterCommented:
Use Copy and Paste instead of Cut and Paste then the rows will remain in Sheet1 also.
0
 
Rob HensonFinance AnalystCommented:
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
0
 
drtopservAuthor Commented:
Perfect0!!
thanx alot thats what i want exactly :]
0
 
gowflowCommented:
Your welcome my pleasure glad I could help you.
gowflow
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.