jhonny
01-24-2016, 01:03 PM
Hi all,
Attached is a workbook template that I use to find new users by comparing current month with the previous month.
Can somebody help me to add another command button and when I click that command button I want the VBA
code to compare the two sheets and find out the “Financial Department PharmaRES ” role changers.
eg;
Sometimes people move internally to another department, let’s say, Adam1 Anna1 (A1) is already in both sheets Nov & Dec, assume that his “Financial Department PharmaRES ” changed to PDSF to PDSL. So, the Task Abb will show PDSL+_+K2 in the new results sheet.
If the user change their department, their task ID will change too.
Correct Task ID is provided in the Task ID sheets. So, when I click the command button I want to find the Financial Department PharmaRES
changers and to find their appropriate task ID from the Task ID sheet.
Hope you guys can help me on this.
cheers,
-Jhonny
Attached is a workbook template that I use to find new users by comparing current month with the previous month.
Can somebody help me to add another command button and when I click that command button I want the VBA
code to compare the two sheets and find out the “Financial Department PharmaRES ” role changers.
eg;
Sometimes people move internally to another department, let’s say, Adam1 Anna1 (A1) is already in both sheets Nov & Dec, assume that his “Financial Department PharmaRES ” changed to PDSF to PDSL. So, the Task Abb will show PDSL+_+K2 in the new results sheet.
If the user change their department, their task ID will change too.
Correct Task ID is provided in the Task ID sheets. So, when I click the command button I want to find the Financial Department PharmaRES
changers and to find their appropriate task ID from the Task ID sheet.
Hope you guys can help me on this.
cheers,
-Jhonny