Sometimes it is just easier to write a program to automate the task and Excel has an easy-to-use programming language built into all versions, VBA - Visual ...
www.i-programmer.info