Hi Max

You can't just copy n paste all at one go.
we can't just "delete" (ie clear the contents of the visible filtered
rows) all at one go

If you have Autofilter applied in the way described, you can.

Case 1
With filter applied, type Honda in the first visible cell, and use the
fill handle to copy down. Only the cells in the visible range will have
their contents altered to say Honda.
Case 2
With Autofilter in place, mark the range of cells in column D and press
Delete. Only the visible cells will have their contents deleted.


--
Regards

Roger Govier


"Max" wrote in message
...
"jseven" wrote:
.. Then select "contains" then enter honda.
Then just copy Honda into all the filtered rows

Problem is, think we gotta do that copying cell-by-cell in the filter
mode's
visible cells for col D. You can't just copy n paste all at one go.

Then undo that filter, and do it again
This time select "does not contain" then enter Honda
Then just delete all the contents of those cells

Ditto - the same problem as the above, we can't just "delete" (ie
clear the
contents of the visible filtered rows) all at one go. Gotta clear it
cell-by-cell.

I've posted perhaps an easier way to do the above using a helper col.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---