Hi, could some one help me with this...
Im having an Excel where there is one "Main" sheet where all the data is. Based on the value on column I specific cells (A, B, C, E, F, J, K L) are copied automatically into another sheet. There are multiple sheets (all named by employee name) and the macro should recognize in which sheet the rows should be copied based on "Main" sheets column J (employees name in this column, same as there is in sheets).
Is this possible to solve?
Im having an Excel where there is one "Main" sheet where all the data is. Based on the value on column I specific cells (A, B, C, E, F, J, K L) are copied automatically into another sheet. There are multiple sheets (all named by employee name) and the macro should recognize in which sheet the rows should be copied based on "Main" sheets column J (employees name in this column, same as there is in sheets).
Is this possible to solve?