I'm wanting to automate a few things in Excel, problem is I am definitely not a programmer / scripter so this is all foreign to me. I have a list that changes i
If you create a new table in Excel and look at the column width in "Normal" view mode, it will be 64px Now if you switch to "Page Layout" mode and look at the c
Dim path as String dim a as string dim b as string a = range("A4") // variable name in cell b = range("A106") // variable of other name in cell Workbooks.Open
I have a procedure called TableNumberSequence that adds a table row, pauses for a second and then adds another. It does this up until what's specified in the co
I'm new on using phyton for optimization (usually I simple use Ms.Excel) and this is my first time asking on stackoverflow. Usually in Ms. Excel you can add con
This is what I want to achieve with the code further down: If I use the RETURN key, the cell right next to the current cell should be selected, rather than the
Please help me convert simple formula for auto increment with condition - =Arrayformula(if(D2:D="",,countifs(D2:D, D2:D, row(D2:D), "<="&row(D2:D)))) I'v
I am trying to find a specific subject in a shared outlook calendar on a specific date. The subject, the date and the shared calendar is passed as arguments. Th
I have excel file with 2 tabs. First tab is "Summary" and 2nd tab is "Employee". The format of excel looks like below. Please note that below excel is for showc
I am trying to print out a cell from an encrypted Excel workbook. The cell contains a time and when i try to print cell.getNumericCellValue(), the result is a r
Here you are a minimal, reproducible example with the error. I have a class CreateXSSFColor. Firstly, I define the styles estiloBasico and celdaVaciaGris. When
I want to delete all the rows containing the word "Resigned" only in column O. This is my code below to process 331,000+ rows. Is it the most effective or fast
I'm trying to use search in a description to see if there is an exact match to the field in another table. I used the code from How to search a row for a subst
I have tried numerous ways but have failed to get the right data to the new columns. The column description contains a lot of information in which I want to ext
EDIT1: download file with 2 days of real data My home automation controller collects data from several 4-in-1 motion sensors in different rooms of my house. The
I have a few spreadsheets with various tables in different formats. My task is to locate and identify anything on the spreadsheets that can be considered a tabl
I have an xlsx workbook on my desktop with existing sheets. I have a dataframe in R that I would like to add to this workbook as a new sheet. Using library(open
I'm using this code with vb.net and I'm successfully connecting to the database. However when I try the same code in Excel I'm getting error "run time error 37
I have a really large dataset with a column showing (date and time), X-coordinates the object, Y-coordinates the object, Z-coordinates the object, and speed the
I'm trying to build a second tab in my Excel Add-In and I can't get it to work. I've basically duplicated my first tab and if I delete either tab, they show, bu
digital-ocean