david gabra
Member
Hi
I know how to solve the following by performing 2 pivots table, identifying duplicates,
filtering, copy to a new tab..... I managed to what I will explain...took me a log time, someone okay with excel. I tried explaining how to do this... but it did not work, the person did not understand. so I thought maybe a macro will do the job... hence my post.
Here is the requirement.
I have a list of employees and I need to identify who received a salary raise. In this excel, it is termed as 'Exempt Salary' and also 'Non Exempt Salary' (column B).
Basically, column E and F show the start and end date of the salary period, so if a person has the following (2 rows in excel), it basically means that the the person received a new salary.
[once again - only applicable if a person has two rows]. If a person only has 1 row - Please ignore]
In the example, for employee 111, the new salary of 25,000 is valid from the date of 04-Nov 16. The old salary of 20,000 was for the period of until 13-Nov-2016
Here is the magic VBA I need.
I need to identify all such occasions (for an employee that has 2 rows for salary changes) and to able to state summaries the changes on one row showing the the following the old and new data and then the differences.
I have added an example tab - hopefully that will make everything clear.
Thank you for anyone who can solve this dilema how to automate for 1000s of lines.
I will attached a sample excel file, showing how the output should look like.
Thank you once again anyone who try this challenge, and save the numerous manual steps needed for and automated with a macro.
I know how to solve the following by performing 2 pivots table, identifying duplicates,
filtering, copy to a new tab..... I managed to what I will explain...took me a log time, someone okay with excel. I tried explaining how to do this... but it did not work, the person did not understand. so I thought maybe a macro will do the job... hence my post.
Here is the requirement.
I have a list of employees and I need to identify who received a salary raise. In this excel, it is termed as 'Exempt Salary' and also 'Non Exempt Salary' (column B).
Basically, column E and F show the start and end date of the salary period, so if a person has the following (2 rows in excel), it basically means that the the person received a new salary.
[once again - only applicable if a person has two rows]. If a person only has 1 row - Please ignore]
In the example, for employee 111, the new salary of 25,000 is valid from the date of 04-Nov 16. The old salary of 20,000 was for the period of until 13-Nov-2016
Here is the magic VBA I need.
I need to identify all such occasions (for an employee that has 2 rows for salary changes) and to able to state summaries the changes on one row showing the the following the old and new data and then the differences.
I have added an example tab - hopefully that will make everything clear.
Thank you for anyone who can solve this dilema how to automate for 1000s of lines.
I will attached a sample excel file, showing how the output should look like.
Thank you once again anyone who try this challenge, and save the numerous manual steps needed for and automated with a macro.