|re: ”insert below by the number in the cell in Column J minus 1."|
Do you mean that you want to insert a number of rows below the original based on the value in Column J? e.g. J6 contains 4, therefore the row should be copied to Rows 7, 8 and 9. The "new" J10 contains 2, so the row should be copied to J11, etc. is that correct?
Is this something you want to happen as soon as a number is entered/changed in Column J, or is this something that you want to run against an existing sheet?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.