Search results

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

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

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

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

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

Hello Friends, I have a sheet with 2 dropdown lists updated in the cells E10 & G10. E10 has the list of the managers and G10 has the list of engineers associated with the respective manager. Is there are an option where the dropdown list of cell G10 expands (same as you click on the pointer...

Team, Is there a way to stop a running VBA code? Have a code which loops based on a condition and the condition has gone wrong and inturn executing the code to run for ever. Any quick thoughts? Raja

Friends, Is there an option to have formulaes "invisible" without protecting the sheet? Thanks & Regards, Raja

Need small help in getting a desired format through VBA script: My code takes a value from a cell which is in date format and it gives the output in "1/8/2013" format.Below is the code: "Your reporting day would be on" & "" & "" & Sheet1.Range("G" & (Cntr)).Value and the output for this is...

Hello All, I have a file which talks about the data of the new recruitments along with their joining dates. Can I have an option where there would be some kind of "ALERT" poping up exactly a day before the joining date of the employee even when my report file is inactive/closed state...

Hello Friends, I have a data dump which is enormous.here there is column which has multiple queue details as : DEV-.NET-L1 EIM-DSER-L3 BIP-PUBLISHING-L1 EIM-DQCORE-L1 BIP-ADMIN-L1 RA-CR-L1 BIP-DEPLOYMENT-L1 EPM-BPC-MS-L1....like wise there are more than 500 + unique queues Now I want...

Hello Friends, Need help in extracting the required numbers out from the data dump which is in a complex and disorganised format. Please refer to the attached file which has 2 sheets 1) Dump & 2) Report. The data in the dump sheet is basically the login and logout details of the employees...

Hello Friends, I have a sheet which has conditional format applied to a set of cells. I applying a VBA script (pls refer below) in this sheet to hightlight the "ACTIVE CELL" but when I am doing so, the current existing conditional format applied for other selected cells gets deleted. Is there a...

Hello Friends, Is there a script to set a "Combo Box" in a blinking mode? I'm aware of the VBA (below) to set a cell in a blinking mode Sub Auto_open() With ThisWorkbook.Worksheets("Hiring Dashboard").Range("A1").Font If .ColorIndex = 3 Then ' Red Text .ColorIndex = 2 ' White Text Else...

Need a VBA script to replace a particular blank cell with an active cell value for e g in the spreadsheet cell A1 is blank and when I select cell B1 which has XYZ value, this value should be reflecting in cell A1 and in the same way if I select cell C1 which has “123” value then the same should...