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
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
Hello Team,
I have enclosed a sample file which has a kind of month calendar. Now I am looking at an option where the current date (today date) should have a different color from the rest. For example the color of today's date 14th March 2018 should be say red color and tomorrow when i open the...
Apologies for the inconvenience. Let me rephrase my requirement
1)Data in Sheet 2 is connected with Sheet 1. There will be scenarios where based on the data of Sheet 1, Sheet 2 will be having no values to display
2) Therefore on this instance when there is no values to be displayed in table of...
Hello Team,
Please refer to the attached sample file. I am looking for a macro which pops up a dialogue box saying" Sorry no data available" when there is no data in the table. And whenever there is any data updated in the table then there shouldn't be any pop up box appearing
Thank You
Hello Team,
I have two columns where column "F" is the data column "G" is the output. Need a formula where I can get the sequence of "1" in ascending order (column"G"). Kindly refer the sample file and Please suggest a formula for the same.
Thank You
Hello Team,
I have a file which contains the list of tools with an expiry date. Is there an option where I can get am email notification when ever there is any tool which is due in next 30 days from the current date?
Please refer to the attached file
Regards