Copy data from one Excel to another and recognize the right Tab name and Project name

Dear all,

I’m trying to build the following Excel application. We have two Excel files: ProjectControlling Christmas (which is the source file) and Staffing Timeline (Which is where I want to paste some info from the source file).

The app should read the ProjectControlling Christmas and for each staff member (each non-empty row) should copy the % values from Jan to Dec, go to the Staffing Timeline Excel File, search the right staff member tab, search the right project in the tab (Christmas) and paste the values.

So far I managed to copy a row from an Excel to the other (in attachment) but I am not able to automate by reading the right staff member and the right project.
Project Controlling.zip (161.8 KB)

Any help is appreciated :slight_smile:

Kind regards,

GB

Anyone? Thanks