• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    Day wise Time Report

    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
  2. J

    Day wise Time Report

    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
  3. J

    Highlight the current date

    Hello Narayan, 100/100, thats perfect Thank You
  4. J

    Highlight the current date

    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...
  5. J

    Dialogue Box

    Thank you so much Marc
  6. J

    Dialogue Box

    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...
  7. J

    Dialogue Box

    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
  8. J

    Need a formula

    Thank You G.
  9. J

    Need a formula

    Dear Shrivallabha, Many Thanks. your input is perfect
  10. J

    Need a formula

    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
  11. J

    Automated E Mail Notification

    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
Back
Top