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

    How to link ActiveX Control button to a Pivot Table [SOLVED]

    SirJB7, Thank You so much for your assistance I was exactly looking for this Regards, RK
  2. R

    How to link ActiveX Control button to a Pivot Table [SOLVED]

    Hi Luke, Tried using your inputs but couldnt figure out, please refer to the sample file and assist me in getting the desired result https://www.dropbox.com/s/l3arfyvxqr9vtus/MTD.xlsm Regards, Raja
  3. R

    How to link ActiveX Control button to a Pivot Table [SOLVED]

    Hi, Please let me know how to link a Active X control button to a pivot table. I have list of names in the drop down button and a pivot table with the same list of names & data. Now all I need is when I select a particular name in the drop down, the pivot table should have the same name...
  4. R

    Help on VBA scripting - Copying Sheet

    Hello Friends, Am working on a daily report template and looking out for scripting assistance to complete this task. below are few requirements which need to developed 1) A macro to create a copy of the active sheet but the new sheet should carry blank for cells:D4, D7, D8, D9 likewise till...
  5. R

    Need help on VBA Scripting II for printing images

    Ops, am again on the wrong track, Thanks for correcting me. My e mail ID: xxxxxxxxxxxxxxxxx Thank You RK EDITED (SirJB7)
  6. R

    Need help on VBA Scripting II for printing images

    Greetings SirJB7, Please don't embarrass me by using words like "Apologize". A person of your stature deserves unconditional respect and appreciation. And in regards to the VBA support can you please share your e mail id so that I can share the sub folder consisting confidential images...
  7. R

    Need help on VBA Scripting II for printing images

    SirJB7, I am sorry for the frustration caused but I never knew that the management would ask something like this after I shared the Expiration file created by you.. Till date whatever I have asked on this forum, each time one or the other have responded and provided a solution, may be this...
  8. R

    Need help on VBA Scripting II for printing images

    My sincere apologies for this miss. I was not aware of the copyright laws or the implications of the copying the images. I have deleted the file and uploaded a new one Also moving forward I would have a well self explanatory title for my topics Now, can you please help me out with what I am...
  9. R

    Need help on VBA Scripting II for printing images

    Hello Friends, I'm building a template which would store all the vital documents like passport, visa, etc etc of the employees associated with our company. Now am looking for a scripting which would run the "PRINT"command for ONLY the selected employee and the selected documents For eg, if...
  10. R

    Help on VBA Scripting

    SirJB7, Mission accomplished and this happened only because of you. Thank you so much for being so helpful and supportive And your Lamborghini Aventador would be ready upon your arrival on my land :) SirJB7, am working on few more templates and need your assistance in coming days as well...
  11. R

    Help on VBA Scripting

    SirJB7, Need bit more assistance from you In the template, there are few things which are mandatory for every employee like passport, visa but not everything like few might have driving licence and few don't. Where ever an employee is not holding the relevant card, i will mention as "N/A"...
  12. R

    Help on VBA Scripting

    SirJB7, Amazing stuff, this is beyond excellence I checked the sample file and it does exactly, in fact much more than what I wished for Many many Thanks for your time and effort And 15K is nothing for you, come to my place, you will get better than that RK
  13. R

    Help on VBA Scripting

    Hello Luke, Thanks for the advice. I understood the formula used in birthday template but I am stuck how to create the auto trigger of the mail and if am not wrong this can be done only through a macro Any input on this? RK
  14. R

    Help on VBA Scripting

    SirJB7, Much thanks for your response. I did the custom check and found results which have been answered as per the query, something like customized solutions for each different query. Considering my expertise on macros, I am new and find hard to understand and tweak the code to suit my...
  15. R

    Help on VBA Scripting

    Hello Friends, I am working on a employee data base file which has the details of their passport, visa, licence etc and each input has a EXPIRY DATE. Now am looking for a script which would automatically trigger a mail when there is an expiry date which is less than or equal to 30 days (1...
  16. R

    Need assistance in building Employee Schedule Template

    Thank you so much, Faseeh 10/10 Regards, RK
  17. R

    Need assistance in building Employee Schedule Template

    Hello Friends, Need your assistance in creating an employee schedule template. Every week I do the schedules manually using few excel options like cut, copy, paste, delete, format for 200+ employees which is very laborious and time consuming. Need some VBA scripting for the excel sheet which...
  18. R

    Excel novice

    Hi Andrew, Please apply the below formuale (assuming A1 has the value) =IF(A1<=3.99,24,IF(A1<=5.24,18,IF(A1<=6.99,12,IF(A1<=8.49,6,0)))) Hope this should help you. Regards, Raja
  19. R

    Format styles disappear upon refreshing the pivot table

    Team, I have formatted a pivot table (color fill, bold, text aligment etc ) but whenever I refresh the pivot table, the formatted styles disappears and the table gets back to its default look which is very annoying I have checked the "Preserve the format on update" in the pivot table...
  20. R

    Congratulations Bobhc - 1,000 Posts

    Congrats Bobhc!!! No words to express our gratitude to you for the enriching experience we had gained through your posts Regards, Raja
  21. R

    Matching row numbers

    @ fionamb83 I'm not sure if I got your question in the right way but below is my view Please input the below formula in cell D1: =OFFSET(A1,(MATCH(A1,B:B,0))-ROW(A1),2) Hope this should work for you Regards, Raja
  22. R

    Attendance spreadsheet - how to use vlookup to count days

    @big d 51 The best and the simple way of getting the absent hours is through a pivot table. You just need to have a helper column which would get the "year" from the dates. or As said by Luke, you can get those absent hours by using SUMIFS formula. Please refer to the link if incase you...
  23. R

    Auto exit after reaching the threshold time

    Hi Narayan, Much thanks for sharing the link. I was just looking out for this. The code works as I wished but is missing out on one aspect. There should be live timer dispayed & running. If not a timer atleast a pop up box something in a rectangle/square or circle form written as "This file...
  24. R

    Auto exit after reaching the threshold time

    Hello Friends, Greetings for the day!!! I am looking out for a VBA script which should run a descending timer after opening an excel file and the file should auto exit once the timer clocks 00:00:00. For example, I have set a threshold time of 5 minutes to edit/view a file post which the...
  25. R

    Auto expansion of Dropdown list

    @Narayan & SP: Absolutely Fantastic. People sitting next to me are stunned watching this magic. Many Many Thanks dear friends :) Raja
Back
Top