Posts by Belgyboy

Does anyone have any idea how to insert rows or columns, if values are missing? If else move to the next row or next column?

Any idea is welcome, thanks

Hi davesexcel,

Please see attachment with before and after.

I'm basically looking to create a loop where it adds a row and a column if that number is missing, for all sheets in workbook.

Any help or tip is super welcome

Thanks!!

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!!!