Solved

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

Posted on 2013-01-01
5
616 Views
Last Modified: 2013-01-05
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.
0
Comment
Question by:drtopserv
5 Comments
 
LVL 20

Expert Comment

by:Russ Suter
ID: 38734598
Use Copy and Paste instead of Cut and Paste then the rows will remain in Sheet1 also.
0
 
LVL 32

Expert Comment

by:Rob Henson
ID: 38736230
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
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 38739260
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
 

Author Closing Comment

by:drtopserv
ID: 38747061
Perfect0!!
thanx alot thats what i want exactly :]
0
 
LVL 29

Expert Comment

by:gowflow
ID: 38747109
Your welcome my pleasure glad I could help you.
gowflow
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Advice in Xamarin 21 56
ADD New Entries 7 16
Avoid Multiple Instances of Named Ranges in Excel 3 16
Excel - Transposing columns/rows (sort of!) 7 12
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now