advanced filter
 

I am starting with a range of say, a2 to f100, on spreadsheet A. I ru
a filter that reduces the range to a5..f10. Later filters of the rang
will highlight other areas of the range, such as a10..f20.

I would like to pull whatever the filtered result is from spreadsheet
to spreadsheet B. The size of the filtered output varies from run t
run. I would appreciate any ideas

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

advanced filter
 

One way:

With Range("A2:F100")
.AdvancedFilter <your arguments here
.SpecialCells(xlCellTypeVisible).Copy Sheets("B").Range("A1")
End With

In article ,
bdh2004 wrote:

I am starting with a range of say, a2 to f100, on spreadsheet A. I run
a filter that reduces the range to a5..f10. Later filters of the range
will highlight other areas of the range, such as a10..f20.

I would like to pull whatever the filtered result is from spreadsheet A
to spreadsheet B. The size of the filtered output varies from run to
run. I would appreciate any ideas.