cut filtered-selected rows from a sheet1 then paste in another sheet2
Posted on 2013-01-01
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.