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

    [Outlook] VBA to Match the 6 digit code in the email subject line with the same code in the name of the attachments

    VBA in outllook... I couldn't find right forum so posted here as usual.
  2. A

    [Outlook] VBA to Match the 6 digit code in the email subject line with the same code in the name of the attachments

    Yes... point 3.. It should be all of the attachments. Currently i am using below code. Where i need to enter the code manually. >>> use code - tags <<< Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) If (TypeOf Item Is MailItem) Then Dim strMsg As String Dim...
  3. A

    [Outlook] VBA to Match the 6 digit code in the email subject line with the same code in the name of the attachments

    Hi, I sent out lot of emails in a day and chances of attaching wrong attachment to wrong code is very high. I am looking for an Prompt msg in Outlook when we hit on send by matching 6 digit code in the subject line with the name of the attachments. If the code in subject line does not match...
  4. A

    Need VBA in msWord

    Hi, I have created NIGO template in excel to paste the selected NIGO reasons in msWord(NIGO_Template) after 2nd paragraph. things are fine till here I am looking for a VBA form in msWord (NIGO_Template) itself. I want all the NIGO reasons as a check points in the form, which ever is selected...
  5. A

    VBA to Save workbook in multiple sub folders

    Thank you so much for your input.. its actually a Template and Saving the workbook in all the folder is our job... People will go to each folder and take it forward from there.
  6. A

    VBA to Save workbook in multiple sub folders

    Hi, I have a workbook named "2020Help". I need to save this file in almost 2000+ folders. folder name is not unique but the subfolder name is "2020help". is there a way to search the sub folder name and save the file in it. Any help will be greatly appreciated
  7. A

    Work allocation via VBA

    Under the Sheet name “MO.Individual Training Tracker” Column A has task type and Row # 2 has employee names.. And their training status Trained (TR) Not Trained (NT). Based on the Trained (TR) status, Column F in Sheet “MOWorkAllocation” should update. I have updated the expected result in...
  8. A

    Work allocation via VBA

    Anyone please assist me on this...
  9. A

    Work allocation via VBA

    Could you please run the macro.. After running the Macro, Under 'MO.DailyAttendace' Sheet you will see the staff names in column F. Allocation in column F is not happening properly..
  10. A

    Work allocation via VBA

    Thank you for your time.. "MO_AmeritasWorkAllocation" file already has a VBA which is pulling 'task ID', 'Task Type', 'Action Step' & 'Workbasket' from "realtime_sla_role.xls.xlsx" file... Then allocating the tasks to the User ID's (Which is in "MO_AmeritasWorkAllocation" file under "MO.Daily...
  11. A

    Work allocation via VBA

    Hi, I am creating Macro to allocate the work to team members. I have created a VBA however there is some issue with the looping. In the sheet 'MO.Individual Training Tracker' i have stored all the task types, employee name and there training status. Whenever VBA is allocating the tasks it is...
  12. A

    Daily Volume tracker for the team

    People work on different engagements which need not to capture in this tracker... This tracker will be specifically used for one set of work. Make selections and press start… Start working After ‘duty’ is done.. they may start different engagement so it’s better to stop the work come back...
  13. A

    Daily Volume tracker for the team

    SAVE button should be changed to Start and End Button. Once a START button pressed then the time should start and once we Press END button it should stop the time.
  14. A

    Daily Volume tracker for the team

    Yes the information which is on form is enough. I feel entering date manually will be fine bcoz we work in night shift which means login @ 05:00PM and logout @ 02:AM.
  15. A

    Daily Volume tracker for the team

    I got the basic steps.. I didnt understand 'user make needed'
  16. A

    Daily Volume tracker for the team

    Once we select 'Duties' Will it take us to the 'form' to enter the details?
  17. A

    Daily Volume tracker for the team

    How about giving a space in the 'form' to enter the time manually by the people. Yes, Each person will use own file and'master' fill should pull data from those 10 files
  18. A

    Daily Volume tracker for the team

    As of now we dont have any tracking mechanism to capture the accurate time. With this tracker we need to capture the time for each task. Data in 'Monthly time' is blindly added to match 480 mins/day
  19. A

    Daily Volume tracker for the team

    Times are captured in 'Monthly Time' tab with the same format as 'Monthly Volume'.
  20. A

    Daily Volume tracker for the team

    yes it is... If we are getting the "time taken" as well in the same way
  21. A

    Daily Volume tracker for the team

    Dates, request type and action taken.. These are details will use in Monthly Volume
  22. A

    Daily Volume tracker for the team

    I added items which we use in user tab. From column G to N. The data i have given is for the user 'Viral Avlani' only.
  23. A

    Daily Volume tracker for the team

    I have corrected the data and added piovt table.. Monthly time is blindly added to match 480 mins/day so data is there not there for it
  24. A

    Daily Volume tracker for the team

    If its the question of mismatching in number from Daily Volume to monthly Volume please ignore.. As its a manual data things are captured and reported very badly.
Back
Top