Good evening to the forum.
I need your help with the excel concatenation.
In short it is a Leave Program and I want to include in it a Shift Program.
Let me tell you that I am a beginner in excel, and I completed the first part with a lot of help quite some time ago.
I am asking for your help for the second part.
I understand if someone doesn't want to get involved, because of the many parameters I'm asking for.
It would also be good with functions and not vba, since the pc that will work is in a closed network with restrictions on vba. On my pc I have office 2019 but where it will work, it has office 2016 and below. Now if it can't be done with functions and requires code, let it be done with code.
Shifts can generally be rolling or random. (I prefer the second).
Inside the file, it is in Greek (columns, cells, etc.), as well as the formatting of the dates. The instructions I provide within the file are in English.
I know it is a very difficult task.
Thank you in advance.
With regards / respect.