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

vladimiratanasiu

Active Member
Joined
Dec 17, 2010
Messages
347
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
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!
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Forum statistics

Threads
1,223,894
Messages
6,175,252
Members
452,623
Latest member
Techenthusiast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top