is it possible autonumbering multiple columns based on select active cell?

**ABDELFATTA** · 10-14-2020, 09:43 AM

hello
i put my expected result in sheet 1 the numbering should in col a based on select active cell in column b , col c based on select activecell on col d the numbering should in col a,c
thanks

**alansidman** · 10-14-2020, 11:13 AM

You can modify this as needed for particular column or prefix.

Please Login or Register  to view this content.

**ABDELFATTA** · 10-14-2020, 12:52 PM

thanks alansidman for this code actually i'm looking for way do that by worksheet change event just if i fill data every cell in col b or col d

**alansidman** · 10-14-2020, 12:53 PM

Please Login or Register  to view this content.

Explain this with an example as I am a little dense today and it is not clear to me what you are asking.

BTW--this was not evident in your original ask. Try to be specific to your needs in the future. It will speed up responses and solutions and avoid these back and forths.

is it possible autonumbering multiple columns based on select active cell?

LinkBack

Thread Tools

Rate This Thread

Display

is it possible autonumbering multiple columns based on select active cell?

Re: is it possible autonumbering multiple columns based on select active cell?

Re: is it possible autonumbering multiple columns based on select active cell?

Re: is it possible autonumbering multiple columns based on select active cell?

Thread Information

Users Browsing this Thread

Similar Threads

Using offset function to select a range of cells based on active cell location

[SOLVED] syntax to select cell in another sheet based on offset of active cell in current sheet

Excel 2007 : Select cells below active cell that are equal in value to active cell

VBA - Can I select a new active cell based on the value of the current active cell?

Select sub based on which cell is currently active

Select a Range Based on Active Cell Location?

Select columns of active cell's row

Bookmarks

Bookmarks

Posting Permissions