Parse Data from file and assign to columns on another worksheet looping multiple records

Hi,

I'm having trouble with the attached. I need to take the data that's in the first tab and break out the relevant information to place it on the Output tab according to the headers. I was trying to loop through row by row and find the relevant text, and then paste the data following the keywords according to the headers on the second tab, but I can't quite figure it out and it's giving me a headache. If anyone can help me I would be most appreciative. There are only two records on the attached Data sheet, but in practice there could be over a hundred such records.

Thank you.Test.xlsm

Hi

As there are some items that could come from multiple places (Due from Clients, Amount from clients) can you please complete the output for the example data, and explain exactly where that data has come from.

rylo

OK. Attached is a workbook with a manually completed set of Output from the first record along with the location of the cell from which the data was taken. I have also included an additional tab of scaled back requirements if the Output tab is too cumbersome. (I know it was for me).
Ideally I would have all the information from the Output tab parsed out, but I can make do with the scaled back version at least to start. I am self-taught on VBA and it's been very difficult to find the right approach to this problem. I initially thought it would be simple to search for specific text and pull the data that follows, but I seem to be in over my head at the moment.

Thank you so much for your help.

Test.xlsm

Hi

OK, here's a start. It is based on your file from #3. I'm not sure of the output in column D as it doesn't really show if it is the first 6 Xs or the last 6 Xs.

Please Login or Register  to view this content.

rylo

Thank you so much. This is incredible. Can't believe how quickly you turned this around.

If only I'd asked for help 8 hours ago, I could have saved myself a good deal of frustration. Now all I need is a little error handling to account for anomalies and make it more versatile and I'll be in great shape. Thanks again. You're the best!

Regards,
-Streaker