Need help to arrange system generated data in to User defined format 1

Here I am attaching excel workbook in which “Sheet1” is system generated file and “Sheet2” is User defined file. I need a VBA code to arrange data of as shown in “Sheet2”

I have attached 4 slightly different excel workbooks which will at first look will look same but there are different.

I need VBA code for each excel workbook at arrange data as shown in “Sheet2” of each workbook.

I understand that you needed to attach various files to your thread, but you need to attach them all to the same thread, not open a new thread for each file. I have closed all those other threads you started, so you will need to attach those files here.

Hi guys. I know this looks like duplicates but it looks to me as there are 4 different original formats so each has its own unique solution

The thread is duplicated, the OP just added different files to each thread. Those files need to be included here.

Please go through this attachments as well. Cause I need VBA code for this also.

KRIXXX your files on those other threads are no longer available, I closed them all. So, like I said, you will need to attach them to this thread now.

Also, I tried to open the file from post #1, but there seems to be a problem with it

Hi KRI,

Try below code based on your sample files ...

Please Login or Register  to view this content.