Select the data range for the column where you want the values

do Edit=goto = special and select Visible cells

type BMW in the formula bar

hit Ctrl+enter rather than just enter.

--
Regards,
Tom Ogilvy

"SuperJas" wrote in message
...
Hi,

I'm using a filtered list and need to paste a variety of values into the
filtered/visible cells only.

For example, I have a filtered list showing all the cars that are made by
BMW, and I would like to copy and paste value "BMW" into a new column for
the filtered/visible rows.

As you know, merely pasting or paste-special will paste the BMW into all
the hidden rows in between as well, and I need to get around that.

Many thanks for your help in advance,

SuperJas.