Cutting visible cells in filtered list

[fernipascual]

Hi again:

I need to cut rows from a filtered list and move to another place on the same spreadsheet. I don't want to sort and cut so I need to filter and cut.

Is there a way to do that without cutting what is hidden?

Thanks

 

[Datsmart]

I would suggest using Advanced Filtering.
Good example of Advanced Filter steps here:
http://www.contextures.com/xladvfilter01.html

AdvancedFilter Video Demo here:
http://www.contextures.com/xlVideos04.html

Another good link with sample VBA code here:
http://www.meadinkent.co.uk/xlfilter.htm

Advanced Filter allows you to preset filter options.
It also allows you to filter by criteria in ways standard autofilter can not do. You can choose an export location in the dialog box or in VBA code.
Once you setup the code and criteria, you can use a macro button to copy specific data from your main sheet to a "Report" sheet. The original data remains unchanged and the data "Filtered" to another page can be used as desired.

 

[fernipascual]

Thanks for the quick response, John. I will view the links you sent.

Thanks again