search condition- copy

[Khalil Handal]

Hi,

I have a column DR. Some of it cells are empty and the others are not, they
contain alphabets such as T, TA, SSB... (19 different sets of letters). The
range I need is DR8R200

How can I search the cells of this column in a way that if the cell is full
(contains any of the mentioned alphabets) to select the row of that cell and
copy the entire row to another work sheet in a different workbook with the
name of "WV" and put it in row 7, the next row to be cop will follow in row
8 in the new worksheet.

Is this possible? Any help is appreciated



Khalil Handal

 

[Dave Peterson]

You may want to try Ron de Bruin's Easyfilter:
http://www.rondebruin.nl/easyfilter.htm

Or look at the way Debra Dalgleish does it:

Debra's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

or

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb