I have a VBA User defined function which takes multiple range references for using it in the code. My problem is when I try to use a particular range reference
I got an excel file which should use a query from an ms access file (which is a front end for a ms sql server) But instead of receiving every entry I want to us
so i'm trying to use a macro to look in sheets one code and paste the information of that code , I'm trying to use a simple macro with advanced filters to do th
How do I return an excel file (version: Office365) using FastAPI? The documentation seems pretty straightforward. But, I don't know what media_type to use. H
Is it possible to create a dynamic Excel Pivot Chart title that includes "(Top n)" where n = the value filter row limit selected by the user? I know the chart
I'm trying to return multiple values horizontally into a table from another table (vertical array). I found 2 formulas : = transpose(filter(Result array, x = v
I was using selenium with VBA and there is the current webpage. I was trying to get the bot to select the "exportbutton" ID, but I have already tried Findelemen
I'm a VBA NewBe (this is my first post asking a question on any VBA help site) working on a Property/Expense Management application in excel. the ComboBoxes in
I have multiple xls files in a directory. each file dataframe headers are different but data type is same. 1.xls Location StreetAddress America Pvtld 80
I have an Excel file with many rows and it gets many entries daily. That's why I would like to scroll down the file to last row with data. To find the last row,
I have a log file in csv which has a column contains a list of filepaths separated by comma. I want to split those filepaths into new rows using pyspark(or exce
I can't figure out how to achieve a certain task in my python script. I have a dataframe that contains media coverage for a specific topic. One of my columns na
I have an excel file with multiple sheets, the actual data I need from each sheet is from cell B7 to F38, how can I merge all the sheets' data into one by using
I have two columns in excel, one with a date and one with a rating 'low, medium, high'. I'm trying to write a formula to put in a third column that checks: If A
i want to make a connection with a DBF file through VBA, i have installed all the drivers but i get this error message every time i try to run it Object variab
I am a real novice at VBA, so any help would be welcome. I am trying to convert certain ranges across multiple sheets into only one file. I have written code fo
Suppose we have 2 cells, one contains zero and the other is empty, see the range A2:A3 in the figure: If they pass a FILTER we get two zeros as a result, see t
I have this simple script that creates a list by taking the values out of the column of excel_1 and compares it to the values of a column in excel_2. I want it
I am trying to register some functions and have success up until the length of my string exceeds 255. I have written the below function to cycle through the lis
I have a problem reading the code with openpyxl, until yesterday it works, and now it doesn't work anymore, I tried also with a backup copy but I have the same