Help With Macro To Analyse Data

Went a different route. The forums assistants is no longer needed. Thanks

Hi,
Was wondering if you guys could take a look at the attached speardsheets. I am interested in knowing if a Macro could be easily written to complete the task and maybe offer some ideas on how to go about things. I tried to use formulas but had little luck. Included in the spreadsheet is the steps I use and examples. I have to do this hundreds of times a day and it take up a lot of time and mistakes are made sometimes. Any help or thoughts would be greatly appreciated.
Thanks

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.