I need some excel work done ASAP. Attached is the document with comments stating what I need done. Shouldn't take long for an experienced excel and macro user. Preferebly need it today if possible.

 

It's a large data table with yield and YTM numbers. I need a formula or a macro or a vba code which will automatically generate the yield the day before if there were no trades and automatically calculate the two bonds closest to 10 year maturity to calculate a weighted average giving me a 10 year yield. But like I said all the info is in the excel spreadsheet with comments.