Insert Row based on cell value

  • Hi There,


    I'm looking for a VBA code to insert rows and columns for all worksheets in workbook based on the value in the row and in the column itself. The columns need to be from 1 to 13 and rows need to be from 1 to 31. The starting position is Always B3 for rows and C2 for columns. Some rows and columns are missing. i.e. If there is row 1 and row 4, I need to write a code that inserts row 2 and row 3, until all missing rows are added until row 31.


    I have been able to create loops to insert rows but not based on the value in the cell.


    Can anyone assist me? :)


    I have added an attachment with a screenshot of the excel.


    Thank you!!!