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