No problem, This procedure can be accomplished with about 8 lines of code. Could you post your workbook with the desired result so I can be sure I write it correctly for you. Otherwise I just need to know what you are trying to do with the data. What I can see now is the the data in column T gets copied to column AN. Once it is pasted in AN the data somehow spans to column BP which is the part I dont think is necessary but again I need to see the spreadsheet to be sure. Then column AN gets selected and a text to columns is done. Afterwards each column is processed with a formula and then filled down.



Now if I assume correctly you have data in column T that needs to be changed from 1,2,3,4,5 to 001,002,003,004,005. Now if this is the case again we can write code to do it but You could also just a write a substitute formula in column U and then double click to autofill down. This formula typed in T2 and then autofilled down would work.
The 00 at the beginning is to account for the first number. If this doesnt work the way you were looking post your book with the data on 1 worksheet before your code was run and then on a 2nd worksheet the desired result. Once I have this I think I can have it written in about 15 minutes once I start.

Let me know

Thanks