Copy Data from one sheet to other to change data layout

Hello:

I have uploaded updated attachment.

Please help and Thanks

Riz

Hi Mike:

Thank you for your quick help.
However, when I paste the code, some of the code turns red.
Please check and let know.

Thanks

Riz

Hi Mike:

Thank u, your code works.
However I have changed it little bit as :

Look for digit number like 1,2,3,4,5 and so on in Column A of Sheet1.
Once found, copy data from column A to L for that particular row in Sheet2 starting at cell A2.
Copy the next 2 row (1st 2 column) of data in sheet2 column M,N,O,P as shown in sheet2.

Please check my last uploaded excel file.

Thank u so much

Riz

Hi Mike:

I am sorry, but there is small change needed.

copy data from column A to M for that particular row in Sheet2 starting at cell A2.
Copy the next 2 row (1st 2 column) of data in sheet2 column N,O,P,Q in sheet2.

Once again, I apologize, because of the complication of the data I have.

Please send me uploaded code.

Thank u so much.
Riz

Hi Mike:

Still same result...

Please have a look.

Thanks
Riz

Hi Mike:

I think we got it now.
Let me check and I will let you know in few min.

Thanks a bunch.

Riz

Hi Mike:

You are great.
Saved me bunch of hours.
Its working....I will let you know if any further problem.

Thanks
Riz