Dears please i have a request need some support from you,
in recap, i have a workbook have a "Data" for employees daily for a year, these "data" is related to "Deduction points" and "Rewarded Points".
the 1st worksheet is an interface for userform access, we will use the first that called "Agent login", this form have multiple fields need some inserted inputs and 2 button, called "Deductions" and "Rewards"; as per the filled criteria, will move to a popup sheet called "output" contain the desired data. the other sheets are very hidden
for my request we will use these criteria to have a clear inputs to use
1: at "interface" sheet, hit the icon that called "Agent login" to popup window with 3 field and 2 button
2: at 1st filed insert: sara.shaheen
at 2nd insert: 84166
will not choose a month yet
3: then hit "Rewards" button
now we have the sara's rewards points in a popup sheet with ribbon disabled and a user form with some inputs and some controls
these form export the both data "Rewards" as per 1st userform inserted criteria & "Deduction" as per the used "Username" - Sara.shaheen- and the built-in control for selecting month to retrieve "Deduction" table.
4: there is "Total rewards": count of Sara's total reward points
5: "redemption validation": is each employee can reward his deduction points by own rewards, but there is a condition: every 3 reward points remove only ONE deduction point, this rectangle show how valid points the employee have to use for redemption.
my question is: from this form i have the rewards and deduction points, can the employee redeem his points by hitting in "Redeem" button.
with some rules:
>> Every 3 reward points remove one deduction
>> the rest after redemption still
>> the reward points that redeemed will removed from the source sheet "Rewards", Column "E": called "Total"
>> the deduction points that rewarded will remove from the source sheet "Deduction", Column "Y": called "Total Deduction"
>> at "Deduction" sheet column "AD": "Comments#" beside the rewarded cell a comment will be inserted with eg:"3 point are rewarded" as a reference then
>> a MsgBox before a redemption process with Yes/No option, and also if the process will be once or point by point, it's means: the all reward points will be redeemed at once with one click or 3 points then 3 points etc...
>> with hitting the "Redeem" button to execute this operation need an email will be send from Outlook to:Ahmed.mabdelkader@tedata.net & CC:WFM-follow@tedata.net & Subject: rewarded points & Body: "kindly be informed that the -used user- made a redemption by "#" of his reward points"
note: some modification are made for the above code related in sorting columns, you can use the attached full workbook
the sheet is uploaded to Dropbox as its size overpass 10 m
https://www.dropbox.com/s/he93wh4nfh...ed%29.rar?dl=0
Gratefully,
in recap, i have a workbook have a "Data" for employees daily for a year, these "data" is related to "Deduction points" and "Rewarded Points".
the 1st worksheet is an interface for userform access, we will use the first that called "Agent login", this form have multiple fields need some inserted inputs and 2 button, called "Deductions" and "Rewards"; as per the filled criteria, will move to a popup sheet called "output" contain the desired data. the other sheets are very hidden
for my request we will use these criteria to have a clear inputs to use
1: at "interface" sheet, hit the icon that called "Agent login" to popup window with 3 field and 2 button
2: at 1st filed insert: sara.shaheen
at 2nd insert: 84166
will not choose a month yet
3: then hit "Rewards" button
now we have the sara's rewards points in a popup sheet with ribbon disabled and a user form with some inputs and some controls
these form export the both data "Rewards" as per 1st userform inserted criteria & "Deduction" as per the used "Username" - Sara.shaheen- and the built-in control for selecting month to retrieve "Deduction" table.
4: there is "Total rewards": count of Sara's total reward points
5: "redemption validation": is each employee can reward his deduction points by own rewards, but there is a condition: every 3 reward points remove only ONE deduction point, this rectangle show how valid points the employee have to use for redemption.
my question is: from this form i have the rewards and deduction points, can the employee redeem his points by hitting in "Redeem" button.
with some rules:
>> Every 3 reward points remove one deduction
>> the rest after redemption still
>> the reward points that redeemed will removed from the source sheet "Rewards", Column "E": called "Total"
>> the deduction points that rewarded will remove from the source sheet "Deduction", Column "Y": called "Total Deduction"
>> at "Deduction" sheet column "AD": "Comments#" beside the rewarded cell a comment will be inserted with eg:"3 point are rewarded" as a reference then
>> a MsgBox before a redemption process with Yes/No option, and also if the process will be once or point by point, it's means: the all reward points will be redeemed at once with one click or 3 points then 3 points etc...
>> with hitting the "Redeem" button to execute this operation need an email will be send from Outlook to:Ahmed.mabdelkader@tedata.net & CC:WFM-follow@tedata.net & Subject: rewarded points & Body: "kindly be informed that the -used user- made a redemption by "#" of his reward points"
note: some modification are made for the above code related in sorting columns, you can use the attached full workbook
the sheet is uploaded to Dropbox as its size overpass 10 m
https://www.dropbox.com/s/he93wh4nfh...ed%29.rar?dl=0
Gratefully,