Hey!!

I Have Data in Columns A, B, C.

Assume I select and entry in Autofilter in Column B.

While the filter is on, I wanna enter serial numbers to only that particular entry (Eg. 1,2,3, and so on.)

However, because of the filter when I drag, only the number 1 is being dragged.

Is there a way to achieve that?