Hi all, I've been scouring the net for days trying to find a valid solution for my issue. I would like to either create a macro or formula to do the following (please see attachment):
In the right side column (labeled 'Reason') there are cells with both text and numbers. Some cells contain a single word (the 'Reason') followed by the cost associated with it, some cells contain multiple words (Reasons) and costs associated with them. I need to extract the cost numbers and place their values in columns to the left. Those columns are labeled at the top with the particular 'Reason', allowing me to break out the costs and total them.
Thanks for any help in advanced.