Hello,
I really need your help, I've been looking for a solution but can't find a case like this.
In Sheet1 I have an employee database of around 8k rows and 13 columns.
The 7th column identifies the Business Unit (25 units) and the 11th column the seniority class (8 categories: <1, 1-5, 6-10, 11-15, 16-20, 21-25, 26-30 ,>30).
For each Business Unit and for each seniority class I need to select the first X employees in the database and copy them in a new sheet. X is a number specified in a matrix in Sheet2 and is different for each intersection of business unit and class.
The final result should be a new database in Sheet3 with all records selected, one below the other.
I can't figure out how to set dynamic references, so that the macro can work when the numbers inside the matrix in Sheet2 change.
Thanks in advance for your support
I really need your help, I've been looking for a solution but can't find a case like this.
In Sheet1 I have an employee database of around 8k rows and 13 columns.
The 7th column identifies the Business Unit (25 units) and the 11th column the seniority class (8 categories: <1, 1-5, 6-10, 11-15, 16-20, 21-25, 26-30 ,>30).
For each Business Unit and for each seniority class I need to select the first X employees in the database and copy them in a new sheet. X is a number specified in a matrix in Sheet2 and is different for each intersection of business unit and class.
The final result should be a new database in Sheet3 with all records selected, one below the other.
I can't figure out how to set dynamic references, so that the macro can work when the numbers inside the matrix in Sheet2 change.
Thanks in advance for your support