I don't know how further I can help this OP

Will be helpful if anyone join in this thread and offer a suggestion (VBA)

http://www.excelforum.com/excel-prog...ercentage.html