VB Code to reorganize payroll data as explained

[rmomin]

Hello:

Please refer to attached file.
I have data as shown in the sheet.
Need VB Macro to go thru the data to give output as explained.

Step 1 : Go thru Colunn A and look for text consisting of ","
Once Found Copy the content of cell in Sheet2, starting at Cell A2
This will be Employee Name Information.
Now for this employee, Check data between text consisting "CHECK " and "This" and copy
these data in sheet2 as shown. ( Row 8 and Row 9)

Need to do this to end of the Sheet1.

Let me know if you have any questions.
Thanks.

R

[WideBoyDixon]

Hey. Here's the code I wrote. I hope it's close to what you want:

Please Login or Register  to view this content.

WBD