I have values corresponding to 'Calendar Days.' I'd like to convert this to 'Working Days.' In this example, a 'Working Day' is defined by Monday through Thurs
I am currently creating an automation to fill-in field in the browser (Chrome) with VBA and selenium. Which is currently doing fine. (the site is internal) How
I have a Value 38142 I need to convert it into date format using python. if use this number in excel and do a right click and format cell at that time the value
I am trying to create a subroutine that will take a collection of a bunch of strings, step through it, and check for the existence of a named range or formula t
The goal of this script is to loop through each criteria filtered in Column C, starting from C8 where my header is located. The information below will be a list
I need to count rows in column "rating_status2" with value "unclear" and if they have the same "customer_nbr" only once. How it can be done? The structure of th
The code I'm currently using only allows me to filter then replace certain values. Is there a way for me to filter for lets say column M filter for 0 and replac
I am trying to execute the following Python script from Excel using Sub MacrosTrigger() RunPython ("import MacrosTrigger") End Sub MacrosTrigger.py conta
I have the following pandas Dataframe df = pd.DataFrame([ [['First Line', 'Second line']], [['First line', 'second line', 'third line']], [['first l
I am trying to create a formula that takes a selection of choices from a cell and turns it into a "score", then at the end of the row it adds the score up. I kn
Can anyone please help me in choosing the suitable drug the case: patient A is suffering from hypertension & Kidney disease Drugs: Classified according the
We have an Excel 2016 quoting tool that uses VBA code to compare the product codes entered against an Access database and then update another sheet with the det
I have some code in VBscript that creates an excel object and adds a workbook to it Dim oExcel, oWB Set oExcel = CreateObject("excel.application") Set oWB =
I was just wondering: It is possible to create a click button in VBA Excel that opens the VBA editor when the button is clicked? UPDATE: The p
I am trying to simultaneously read from one sheet and print to another sheet, with additional format. I think my issue has to do with improperly referencing the
I am looking to send meeting invitations for each row in a worksheet. I am able to create an item that when displayed shows as an appointment, not a meeting re
I am new to macros and am having trouble creating a macro that will copy a range of cells and then paste just the values back into the same cells. Basically I
I have an exported xlsx file from c# (through angular).The Properties name which I want to be the columns header change in excel!( the first letters are changed
I have a dataset in Excel which I have imported in SQL Server. Is there a way in which when I make any change in the Excel data set like add/remove/edit rows or
I need to replace or substitute the first instance of a single text character in an excel row. current: B01 TEST TEST TEST A W B 0 A expected result where first