Serial number with AutoFilter

**NeedForExcel** · 04-10-2013, 07:29 AM

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?

**NeedForExcel** · 04-12-2013, 10:23 AM

Any Help???

**:) Sixthsense :)** · 04-12-2013, 11:14 PM

I believe you can't

**NeedForExcel** · 04-13-2013, 08:34 AM

Thank you for the reply..

**waseem ahmed** · 04-14-2013, 07:43 AM

Originally Posted by msexcelathome

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?

Waseem Ahmed

**waseem ahmed** · 04-14-2013, 02:22 PM

Serial number with AutoFilter
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?
Thanking You,

Waseem Ahmed

VBA Beginner!!

**FDibbins** · 04-15-2013, 12:25 AM

waseem welcome to the forum

You have now repeated Post #1 twice, what is the purpose of that?

If you intend to ask the same question, it has already been answered. If you intend to answer the question, then please do. If not, then please do not keep posting the same thread