Hello everyone! I am dealing with the following situation:

I have a table with some data which has a filter enabled. Lets say I want to put at the (consecutive due to the filter) cells A2,A4,A6 (which in the actual case might be a thousand) the values ABC=1, ABC=2, ABC=3.

If I write at A2 the value ABC=1 and then drag from the lower right corner to cell A6, excel doesn't do what I want.
I even tried to do what is described above at an unfilter range, then copy the three cells and then go select A2,A4,A6 and paste, but again excel won't let me do it.

Any suggestions?

Thanks in advance!