Link to home
Start Free TrialLog in
Avatar of drtopserv
drtopservFlag for Israel

asked on

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.
Avatar of Russ Suter
Russ Suter

Use Copy and Paste instead of Cut and Paste then the rows will remain in Sheet1 also.
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
ASKER CERTIFIED SOLUTION
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of drtopserv

ASKER

Perfect0!!
thanx alot thats what i want exactly :]
Your welcome my pleasure glad I could help you.
gowflow