Hi all,

I am looking to write some VBA code that will look for a numerical value in column "O" and insert that amount of rows but minus 1. (So if 3 appears, it will insert 2 rows).

I also need to then copy the information from the rest of the row and paste the values. All the cells contain formula, so I just need to values to be pasted here.

I am completely new to VBA, but quite an advanced Excel user.