Part 1: Please help to advise where did it went wrong. Would like to sort for column E via descending order with header Sub SortRows() Dim destSht As Worksheet
Is there a way to swap many instances of strings at once without nesting? For instance, say I want to drop all instances of the following values from a string:
Okay, totally noob coder here. I'm working on a sheet that has a repeating series of 1 combo box linked to one other combobox and a checkbox. Basically, the fir
Within this picture, an Excel chart is displaying approximately 100 values + times (red curve): Excel is "intelligent enough" to reduce the number of the displ
I'm currently working on a project where I want to be able to manipulate and graph data with relative ease in Excel. However, a lot of the data involved exceeds
I didn't find a solution for this: From a dataframe I generate an excel and some columns need to be in format hh:mm:ss (with no limit to 24h, for example a valu
I have Excel VBA code that imports Outlook mail data from one folder into Excel. I change this for three folders all at the same level (not subfolders). Is ther
I am trying to use an if else statement to delete the entire row when a text value is found in a cell within a given range. The code stops after deleting one ro
I would like to convert the number of digits in excel into respective words as shown in the picture above. How can I achieve this functionali
I was using regularly a macro add-in in excel which stopped working all of a sudden. I get several error messages in the following order when I launch the macro
I'm trying to export all sheets in the workbook as separate pdf files using one button. I followed a YouTube tutorial: https://www.youtube.com/watch?v=FRZ6n3gHt
I am trying to use a vlookup / index to pull some numbers. Sample data attached: A: merged cells (the number is stored in the top of cell of the merge) B: Only
I currently have a Data Pipeline within ADF that pulls data from multiple REST APIs, transforms the data and stores it in an Azure SQL Database and from there i
I am trying to read excel file in pycharm using pandas. I installed the package successfully. My issue is that I am trying to use file location in addition to i
I have an Excel document that is constantly updating it's values every couple of seconds through a link. Is there a way I can trigger some kind of stored proced
If I have table 1 with OrderIDs and CallIDs and table 2 with CallIDs (that are referenced in table 1) and callDates, how can I find the number of orders within
I am trying to convert data from rows with different lengths into two columns. The value of the first column remains equal to first cell of the row and is copie
I created a macro for Excel which opens a list of all visible sheets in a workbook and goes to the desired sheet as you scroll through the list. The idea is to
How do I copy/paste multiple ranges? The code returns the cell A1. What I need: 1- Search and open all Excel files in a folder with subfolders 2- Copy specific
In the sub workbook_open I'm opening 4 workbooks in the background to be able to have references to them without having them "open". (they are not visible) But