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.
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
Last Comment
gowflow
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
Thanks
Rob H
ASKER CERTIFIED SOLUTION
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.
ASKER
Perfect0!!
thanx alot thats what i want exactly :]
thanx alot thats what i want exactly :]
Your welcome my pleasure glad I could help you.
gowflow
gowflow