Details are in attachment.
one text file and a folder with example excel files.
Please download, review and provide bid.
If you do this one well, I have more excel macro work for you.
THIS IS NOT FOR NOVICES. If you think you can do this and not be an expert, you are wrong. I am fluent (not expert though) in Excel and ran into many problems using the IF and ASBLANK statements.
3 freelancers are bidding on average $300 for this job
This is do-able if we combine the macro and Excel VBA code. Hard to do with macro only, but VBA. If you agree using VBA + macro integration, I could be able to arrange one day solution only. Let me know.