Forum Discussion
Calendar for Employees' Vacations tracking
Employee time sheet (weekly, monthly, yearly)
If this Information dont helps, please ... Give more detailed information about your project.
It is best to insert a file (without sensitive data), where you describe your project step by step on the basis of this file.
( Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5 )
Inform us about your computer environment, Excel version, operating system, storage medium (hard drive, OneDrive, Sharepoint, tec.).
In this way you can get a solution proposal that is tailored to you much faster and more precisely,
and you save the helpers a lot of time in that they no longer need to guess what-where-how your plan is. Welcome to your Excel discussion space!
Here you can get help to get on with your project / plan / topic.
But when it comes to commissioned work, you should hire someone to do it for you.
Hope I was able to help you with this info.
Thank you for your understanding and patience
I know I don't know anything (Socrates)
- Hey Niko,
Thanks a lot for your answer!
unfortunately i don't have these information about the PC and the other things that you asked me for, and i cannot send the file because we have here in our company very strickt policies about sending intern template outside the company -_- and the IT has already blocked the ability to upload files online .
however what you sent me is somehow similar to what i am trying to build..
the file i am trying to do has the sheet you send which i will call "Template sheet1" and it should import the attendance infromation from another sheet (lets call it "Employees list sheet2") in the same excel file
so depending on the Employee's name, once i insert an employee's name in the concernd field (Sheet1), the attendance information (which is already inputted in Sheet2) will show up accordingly in sheet1..
anyway, i need it only for Vacations not full attendance details.
i have already watched so many videos and i already build the calendar template, but i am still trying to get the infos in sheet2 to sheet 1 in the correct days ..
thanks alot for your suppor and understanding
best regards
hanaI can imagine what you mean, but in order to be able to offer you an exact solution, as I have written to you, some preconditions would be necessary.
Everything is possible in the world of Excel ... and you can do just as much wrong if you don't know how-where-what-when in advance. Welcome to your Excel discussion space!
Many things can be solved in Excel, with many possible paths, which is why very precise specifications are required.
However, here are two possible approaches that might help.
Or
XLOOKUP function
Two files are attached with examples (I'm not sure you can download them).
Hope I was able to help you with this info.
Thank you for your understanding and patience
- Hello NikolinoDE
thanks so much for the files you've sent 🙂
I am going on with this little project i am doing here,
i will keep on searching untill i find the answer 😄 and will definitally write you about it .
wish you a nice day and stay safe
Rhannah_
