Day wise Time Report

[JudeMarcus]

Hello Team,

Need assistance on preparing a report for my engineers. There are two sheets in the file.
1) Calendar - Here I will enter the data manually
2) Log Time Sheet - Here the data should automatically pop up based on the inputs from calendar sheet

Please refer to the enclosed file

Thank You

 

[vletm]

JudeMarcus
This would be the shortest way...
PS. Would those Engineering inputs be similar for every day?

 

[JudeMarcus]

Hello Ninja,
Thank you so much for your input, you made it look so simple
At times we may have to add new engineer names or the data may shuffle hence a formula to look up the data should be a better approach
Kindly do the needful

 

[vletm]

JudeMarcus
... then You would make 'Calendar'-sheet layout
as it would be more useful to get needed 'Log Time Sheet'.
There are 'interesting' Merges and so on.
... also something should be fixed, 'Calendar' or 'Log Time Sheet'.
Is 'Log Time Sheet' prefilled or which one is like master.
= if You add more names, how You take care space with both sheets.
= if 1st day isn't Sunday ... no matter or what with outputs.