autofilter

A

agenda9533

Using autofilter I retreive parameters(Speed) by/per certain Last Name.
I want to add/copy new data (Time, for example, as another column) to this
selection. Copy/Paste/Special/Values doesnt work- fills only one upper cell.
Please, help.
 
D

Dave Peterson

You pasted into a range that was filtered?

If yes, then data|filter|show all.

You'll see you pasted into cells that were hidden by the filter.

If you're putting the same value into each of the visible cell, you could put it
in one of the visible cells (paste into the formula bar) and drag down.
 
Top