Need help please!

[Topher69]

I only know the very basics of excel, so I apologize if I seem ignorant of a simple question. I have made a UFC game using randbetween and rand. I have it to where it gives me the results of who is fighting, the outcome of the fight, the time and the round. That is figured out for the most part. On another sheet, I have the fighters names and the matches they won and lost. I have to copy and paste manually. I need help on transferring the data to the correct fighter. Here is an example:

<tbody>
[TD="class: xl63, align: center"] Josh Neer
[/TD]
[TD="class: xl63, width: 46, align: center"] def
[/TD]
[TD="class: xl63, width: 208, align: center"] Melvin Guillard [/TD]
[TD="class: xl63, width: 363, align: center"] Split Decision (30-30, 30-30, 30-29)
[/TD]
[TD="class: xl64, width: 61, align: center"] 1:29
[/TD]
[TD="class: xl63, width: 28, align: center"] 2
[/TD]

</tbody>

--------------------------------------------------------------------------------------------------------

Josh Neer
​

<tbody>
[TD="class: xl65, align: center"] Won [/TD]
[TD="class: xl66, width: 176, align: center"] Melvin Guillard [/TD]
[TD="class: xl66, width: 379, align: center"] Split Decision (30-30, 30-30, 30-29)
[/TD]
[TD="class: xl65, width: 64, align: center"] 1:29 [/TD]
[TD="class: xl66, width: 30, align: center"] 2 [/TD]

</tbody>

<tbody>
[TD="class: xl68, colspan: 3, align: center"] Melvin Guillard
[/TD]
[TD="class: xl67, width: 64, align: center"][/TD]
[TD="class: xl67, width: 30, align: center"][/TD]

[TD="class: xl65, align: center"] Loss [/TD]
[TD="class: xl65, align: center"] Josh Neer [/TD]
[TD="class: xl66, align: center"] Split Decision (30-30, 30-30, 30-29)
[/TD]
[TD="class: xl65, align: center"] 1:29 [/TD]
[TD="class: xl66, align: center"] 2
[/TD]

</tbody>

 

[Logit]

.
You will need to edit the title of your thread from "Need help please!" to something that is more descriptive of the issue you are attempting to solve.
One of the moderators will soon bring this to your attention because it is a requirement of this and other Forums.

Think of it in these terms ... you are a new user who has come to this Forum seeking assistance with your problem. How do you expect to get specific
assistance for your specific issue if you type in "Need Help Please" ?

Posting questions here is meant to help you as well as others who search for their needed answers.



Now ... regarding your specific need. It is confusing how you've presented the information for review. We can't determine what is
the initial data ... where that data is located and in what format ... nor is it very clear how that data is to be processed for final
placement.

You will receive an answer to your question quicker if you can post an image of your worksheet/s with sample data ... OR ... post your workbook
with a 'before' and 'after' example of what you are expecting. You can post your workbook to a cloud site like DropBox.com, Google cloud or
similar. Be certain you provide the link for us to download in your next post.

Thanks.