Avatar of drtopserv
drtopserv
Flag 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.
Microsoft ExcelVisual Basic ClassicSpreadsheets

Avatar of undefined
Last Comment
gowflow

8/22/2022 - Mon
Russ Suter

Use Copy and Paste instead of Cut and Paste then the rows will remain in Sheet1 also.
Rob Henson

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
gowflow

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
drtopserv

ASKER
Perfect0!!
thanx alot thats what i want exactly :]
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
gowflow

Your welcome my pleasure glad I could help you.
gowflow