replacing values via VBA form

[Afarag]

Dears,

i have a workbook that contain multiple spreadsheet,

• the 1st "interface" contain 2 userform to retrieve some data based on multiple inserted criteria, when fill the userform data a popup sheet called "Output" will retrieve some columns from the source sheets, the rest of the other sheets are very hidden
• the 2nd "Deduction" contain a big schedule that i retrieve from it some columns
• the 3ed "Rewarding" also use the userform to retrieve a data
• the 4th: "Admin" have the users name and their passwords

i had posted this sheet before and get a great support from @Deepak
http://chandoo.org/forum/threads/retrieve-data-via-vba.19788/page-2#post-122622

but i needed another request,
in brief, this workbook related to employees deduction and rewarding points, the deduction points is reported daily but the rewarding is monthly
Employee can redeem some of his deduction points via rewarding points, but there is a rule, every deduction points redeemed via 3 rewarding points
as i need
at agent userform at Rewarding button i need this data to be preview in a form not in an excel sheet

• for every agent, there is rewarding point data for 2 -last- months: "its mean 2 row only".

want to create a button in this form to redeem the deduction points by this rewarding points.

• need at the redemption form a drop down list for months to let the employee select the month that need to remove his deduction.

>> at deduction sheet, there is a column titled "Comment", when redeem any deduction points beside that cells in comment field need to put eg:"3 points redeemed" with red color
>> need confirmation msg with Yes/No option before achieving the operation
>> when the employee hit redemption button to redeem his deduction points i need another action to notify me via mail by this operation
eg: if an employee will redeem 30 rewarding points, 10 deduction only will be removed, at deduction sheet beside any removed points cell, need a comment in "Comment" column and in the same operation an email will be sent -not displaied- to: Ahmed.mabdelkader@tedata.net CC: salesWFM@tedata.net
subject: rewarding redemption
body: kindly be noted that "username" has been redeem "30" rewarding points
at last need the workbook to be auto-saved after any operation

sorry if there is a fuzzy case.

Gratefully,