Recent content by Raja Kamarthi

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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