Split specific fields from a worksheet in separated files and update automatically the new content.

[vladimiratanasiu]

I posted this message about one week ago, but didn't get any answer yet. It includes the sheets Employees scheduling - general list (see Employees scheduling - general list .xlsx) and Employees scheduling - production departments list (see Employees scheduling - production departments list .xlsx), both of them presenting the scheduling of employees from a firm. The general list (shown partially in the first image) is the source file, from which are exported data to the production departments one (e.g. Rademaker and Fritsch departments – see image 2 and 3). The staff activity is organized on days (date / week day), shifts (1,2,3) and departments. Every department has a permanent and an auxiliary team, described by a specific code of activity (member ID). The general list integrates all elements in a single table, filled continuously with new data from next day(s) or other departments. On the other hand, the destination files have identical information structured on departments (e.g. Fritsch, Rademaker, etc.). Giving the continuous changes of staff scheduling, I need a solution (macro, formulas etc.) to update automatically in each destination sheet the counterpart data from the source file, that are to be added in every next day (e.g. columns 2/3/2022, 3/3/2022 etc.). Thank you!