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
In this example, I have two columns of data: Date and Quantity. Example: (See Screenshot Link) What I'd like to be able to do, with an excel formula (if possibl
I have now twice had this error, where I email a spreadsheet with macros to another person. It is working when I send it using share via email. When they get
I have a workbook - lets call it Book1 Book1 contains 5 worksheets; Sheet1, Sheet1A, Sheet2, Sheet2A, Summary Within the Summary worksheet there is a table whic
I'm trying count number of values from another sheet into column O which has same system name as column B and more than Zero. Could you please let me know the b
Microsoft has web pages showing the local prices for Windows in over 200 countries. For each country, there are separate web pages for Windows Pro, Windows Home
I have a workbook that is about 8mb with about 20 different API calls (via formula in cells) using a 3rd party service. Everytime I try to close the workbook,