Insert rows, serial number and sub serial number

[bavarunbansal]

Hi VBA Champs,
Hope you all are doing well. I need your help/suggestion in automating the following scenarios:

I need to insert 'n' rows below basis the value in #of Switches column and depending on number of rows insert, serial numbers also need to be updated. Example - If two rows are inserted, below serial number '1', the two new rows will have serial number 1a and 1b. Attaching a screenshot of input and expected outcome.


Input Table
Screenshot 2020-10-10 at 7.57.52 PM.png

Expected Outcome
Screenshot 2020-10-10 at 7.59.01 PM.png

I am completely stuck and not able to move forward . Appreciate any help on this.

Thank you
Varun

[mehmetcik]

You will need a macro.

The Macro will need to work from bottom to top

to inset the rows and then the formula to renumber the first column.

This will take me 5 minutes to create. So check back in 5 minutes.

Please Login or Register  to view this content.

[bavarunbansal]

I will wait for your inputs. And thank you very much! You are a saviour!

[bavarunbansal]

I take a bow!!! this is awesome....
thank you thank you thank you thank you very much!!!!