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.