coping row depend on number on the cell , i want to change the cell which has the value

hi
how are you, i'm new in vba , i have sheet with macro , this macro coping data in the row rely on the number which contain in the Column (L) , and the copied data will be in the next sheet(2) with the same formats, my question is that i want to change this Column(l) with anther Column , how i do this ? you will find the macro in the attached



Thank you very much

hi
as you will see in the first picture the micro take the number in Column (L) and copying entire row depend on to sheet 2 in the count of the number in sheet 1 in Column( L) i want to change the Column (L) to be Column (A) as shown in the second picture

Thank you very muchPicture 1.jpgPicture 2.jpg

Hazemrezo,
I think I had wrote this code for you a while back. You need to change this line of code from Column L to column A.

x(i, 12)

INO

x(i, 1)
I have amended the exiting code by removing some unnecessary lines. I have also added another code on module 2 which deals if you want to use column A, but you need to have numbers in column A as you have now in column L.