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.