I play an online multiplayer game which allows players to transport resources to one another. Our team is sending resources to my account and there is a message confirmation which we receive when resources are successfully received in the following formats:
GamerDood1234 sent the following resources or soldiers to your town: Wood x 10000 Food x 10000 Iron x 10000 Marble x 10000 Gold x 10000.
GamerDood1234 sent the following resources or soldiers to your town: Wood x 10000 Marble x 10000 Gold x 10000.
Sometimes they will only send one type of the 5 total resources, but I only want a total of 6 columns (PlayerName + 5 Different Resources). I would like to keep a log of all of these documents, but it takes FOREVER to manually copy the sender's name and each resource type and paste it into the corresponding column to keep calculations.
I need an Excel Macro that will extract specific text from my cliboard containing 100 or so of these reports simultaneously so that I can have these values calculated without so much manual work. I have no idea where to start!
Which commands/functions/scripts will I be utilizing to achieve this goal in Excel?
Thank you for your time in advance. 250 Points awarded to each Response!