Hello to everyone!
I am actively thinking(and working) on transferring data from the "Schedule" to the "Tabell" document. I have a sketch of a macro, but fine-tuning is required.
I need your help in:
1. Remove hard link to the file names.
2. In the macro, specify the path to the "Tabell" file that will open when the macro is started and where the data will be transferred.
3. There are holidays in the chart that are labeled "RV" above the column. It is necessary to specify a condition, if there is such a mark "RV" in the "Schedule", then the employee's working hours are transferred to a new line in the " Tabell" document .
4. Configure the selection and transfer of all employees from the "Schedule" document instead of binding them to the document lines.
The attachment contains my current version of documents . The macro is now sewn into "Tabell", in the future , according to point 2, it will be transferred to "Schedule".
files are available by clicking here)??
I am actively thinking(and working) on transferring data from the "Schedule" to the "Tabell" document. I have a sketch of a macro, but fine-tuning is required.
I need your help in:
1. Remove hard link to the file names.
2. In the macro, specify the path to the "Tabell" file that will open when the macro is started and where the data will be transferred.
3. There are holidays in the chart that are labeled "RV" above the column. It is necessary to specify a condition, if there is such a mark "RV" in the "Schedule", then the employee's working hours are transferred to a new line in the " Tabell" document .
4. Configure the selection and transfer of all employees from the "Schedule" document instead of binding them to the document lines.
The attachment contains my current version of documents . The macro is now sewn into "Tabell", in the future , according to point 2, it will be transferred to "Schedule".
files are available by clicking here)??