please advice how to insert rows based on cell value
>Solution :
As a first hint you can activate the macro recorder in Excel then add a row manually and go to the VBA Editor to see what functions have been called. Then try to understand it. In practical terms what you want is quite straightforward and doesn’t require advanced knowledge in VBA programming so it’s better to try something before asking other people to do the whole stuff for you.