• 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. MaunishP

    Capture Time with HH:MM:SS using shortkey Ctrl+Shift+:

    Giving error : Shortkey must be a letter
  2. MaunishP

    Capture Time with HH:MM:SS using shortkey Ctrl+Shift+:

    Hi Team, Whenever i use Ctrl + Shift + :, it is showing HH:MM format only, i want to record seconds also in it. Please provide me a solution to attached file Regards, Maunish Patel
  3. MaunishP

    VBA - Sending Email using Excel and then copying data from Email

    Hi Sathish, Team member are not able send mail using Microsoft Outlook Webapp. To send mail code works excellent for Microsoft Office 2010, however vba code doesnt work for Microsoft Outlook Web App. Please find below given webapp link which needs to be integrated in vba code...
  4. MaunishP

    How to visualize this data using graphs

    Great Thanks Somendra. Look perfect
  5. MaunishP

    How to visualize this data using graphs

    Dynamic chart would sound good in terms of representation
  6. MaunishP

    How to visualize this data using graphs

    Hi team, Please help me visualizing this data in to graphs, every time i provide this data to my senior in table format. This time i want to do something different. Could you guide me how to visualize this data ? Regards, Maunish Patel
  7. MaunishP

    VBA - Sending Email using Excel and then copying data from Email

    Thanks Sathish its works, if any changes required i will post it.
  8. MaunishP

    VBA - Sending Email using Excel and then copying data from Email

    Hi Sathish, Great this work !!! I have done few changes as required. My Second question is if i have emails coming in a required with specific subject line [date will change daily] from specific team memebers. How will i be able to copy data through macro from Outlook to Excel? Regards...
  9. MaunishP

    How to use IF formula for large database

    Thanks Hui & Somendra, both works well now.
  10. MaunishP

    VBA - Sending Email using Excel and then copying data from Email

    Dear Team, I am trying to create macro where I want my team member to send report bi-hourly basis through Microsoft WebOutlook App using Excel [Small button which says "Send Mail" and same I need to copy paste data into excel against thier name. It is easy to capture data during 5-6 team...
  11. MaunishP

    How to use IF formula for large database

    Thanks Hui, for your valueable inputs. This works however some times team member dont use main door to exit [while leaving office ]or main door to enter [while coming to office]. I would require the first time for team member entering through any door and last time of exit while leaving office...
  12. MaunishP

    How to use IF formula for large database

    Hi Team, How to use if formula for data which gives me door access database. I will require every team members start time and end time from door access database. Searching it manually is okay, however searching it for 150+ members is diffcult. I have attached sheet which contains 2 sheets...
  13. MaunishP

    Calculation / Formulas required - Daily Performance Report [ Actual Hold ]

    Hi Team, Please find attached workbook which has sheet 1 with raw data of a few employees worked on a day. Sheet 2 has data which I want to have it on daily basis. I had done few pivots and was not able to get below given pointers. 1) Actual Hold in entire day for 1 person. Now here is the...
Back
Top