Hi there,
Wish to have a macro that can sort the data of travels of different staff according to team and move it to their respective worksheets/projects.
For instance, I want to see the travel expenses of Jason Bates be moved to Project B sheet (itemized - Note: Meal and Other can be combined in "per diem") when I run the macro.
I work in PMO and I would really appreciate your help if you can create a macro for me to lessen my time working on this because I've been doing this manually.
Wish to have a macro that can sort the data of travels of different staff according to team and move it to their respective worksheets/projects.
For instance, I want to see the travel expenses of Jason Bates be moved to Project B sheet (itemized - Note: Meal and Other can be combined in "per diem") when I run the macro.
I work in PMO and I would really appreciate your help if you can create a macro for me to lessen my time working on this because I've been doing this manually.