Modify Unique Identifier Code to Place Values in Different Column

Hello all,

I am an absolute noob when it come to VBA and mostly I am running other's code without fully knowing what the lines are doing, so please forgive me if I ask something that isn't possible or seems obvious.
Thank you so much in advance for your help!

Overall picture:

I am working on a macro to:
1. take a series of records from one sheet and copy them to another (currently manually done - will work on this later)
2. Replicate those records into multiple copies of the same information based on the value in column "M"
3. Add a unique identifier to the now duplicated values so that each record is now unique

So far I have step two completed with the following code:

Step 2a)

Please Login or Register  to view this content.

Step 2b)

Please Login or Register  to view this content.

I then found a code (below) to add a unique identifier to the repeated values but I want to have these values placed in column "O" rather than right beside the 1st column ("A"). It would also be nice to maintain the leading zeros from the Lot # but I know that can be tricky and it is not essential.

Step 3)

Please Login or Register  to view this content.

I have attached an excel book with a sheet showing the result after step 1 and 2 using the above code (1st sheet) and the result after running step 3 code (2nd sheet)

P.S. if anyone has any hints on glaring inefficiencies or repeated/superfluous statements, please don't hesitate to make a suggestion, I really have no idea what I'm doing

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new I have done it for you this time.)