Hi,
I would like to create a macro that selects the employeename and amount difference for each employeenumber which has an amount in period 20XX-XX that is >1000 than in period 20XX-XX -1. So for example if the amount in 2020-03 is more than 1000 larger than the amount for that employee in period 2020-02. The employeenumber and the amountdifference should then be copied to a row in column F.
I guess i should use an algorithm that, for each employeenumber, searches the amount, than searches for that employeenumber in period 20XX-XX+1 and than for the amount in that row. than it should calculate if the difference of these two amounts > 1000. If so, the employee number and the difference should be selected and copied to row F.
I wrote variables so that the first and last rows for which this algorythm should search is determined. However, i don't have an idea how to create this algorithm. I have been trying for hours but i can't make it happen. Is there a way to do this?
Any input is very much appreciated!
Please Login or Register to view this content.
Bookmarks