|It is not clear to me what you are asking for. These questions are not necessarily in any specific order, they are simply a mixture of the various items that don't make sense to me.|
You say you want insert "a separate row in a new sheet for each "No"
1 - Does that mean that each "No" gets its own new sheet? 40 No's means 40 new sheets?
Then you say "I only want the identifier (column a) and column heading (b1:k1) containing that value."
2 - Are you saying that you want insert a row and copy some data? (You don't say anything about "copying data" in your OP, you only say that you want to insert rows)
3 - What do you mean by "column heading (b1:k1) containing that value."? Are you saying that you want to copy the column heading for the column that contains the "No"?
If so, should it get placed in the same column as the original or someplace else?
4 - "Insert a new row" typically means to place the new row between some existing rows. Do you want to insert a row or to add a row at the bottom of the new sheets(s).
Perhaps a short example of your existing data and the desired output based on that input might help. If you are going to post example data, please click on the following line and read the instructions on how to post example data in this forum. Thanks!
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.