Structuring and updating automatically data from a worksheet as separated files of a workbook.

[vladimiratanasiu]

Hello!

I have 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 is the source file, from which are exported data to the production departments one. The staff activity is organized in the two files 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 source file (general list) integrates all elements (departments, teams, days etc.) in a single table, filled continuously with new data of next day(s) or other departments. On the other hand, the destination file has teams, calendar and ID codes structured on departments. Giving the continuous changes of staff scheduling from the source file, I need to update permanently the same data in the destination sheet. They are related permanently with the items Date, Shift and Member ID (filled with red colour), used as basic constants. I wonder whether is any solution to update by adding automatically in the destination file the new data inserted in the source document. The new data are updated daily (see the XXX columns), but also by other departments (e.g. cleaning, sandwitch etc.) that are not shown in these worksheets. Thank you!