I have this data This code grabs column "BO" and copies it to the right. I need a repeatable macro that copies column BK and inserts it to the right, which push
I am trying to put together the 'Hello, World' of a macro button that will make an option/radio button on a cell in an Excel spreadsheet, the simplest possible
I want to extract a word from text which is separated by commas. This is one of the data from users. 117573,117573,219,219,75,75,Messi,barcelona,53780217,forwa
Here is my code I've set up and is working as a vlookup. (I can follow this and I will understand it when I come back to it in 2 years.) Sub lookup() On Error
I have new entries that go into the Excel table and I constantly want to run to the last row number but it does not work excel.Row.Count() this the problem for
I have a Blueprism process which is locking a column and protecting the worksheet. The cells are then locked. When the file is saved, closed and re opened the c
I have this excel file and I would like to delete all blank cells in columns A and shift the populated cells up using python. Not sure how to do this, any advic
I'm having an issue when I save LabVIEW outputs as .xlsx files. When I try to import with Pandas I get the following error: expected <class 'openpyxl.styles.
Given this rule to follow: And I have some value to check from this: Where cell AA727 is a result of some calculations which I already formatted into a number
I am copying a range of cells with openpyxl from one workbook to another with the following code: import openpyxl import os #Current path path = os.path.dirnam
We are trying to produce an Excel file to calculate a population bioequivalence test as per the FDAs Budesonide Product Specific Guidance (PSG), which can be fo
I have the above cells and i want to substract each individual row . i.e. 137.61-137.61, 132.88-270.49 and print each one of the results on the respective row
I have some existing VBA code that works great for exporting all tabs in my workbook as individual sheets named by the tab name. I just want to be able to set
I am currently working on a power bi dashboard that uses an excel file as a data source. I want to auto populate the excel file with new values from existing ex
Pivot table data source Please see the above image. I am trying to dynamically update the pivot table data source whenever a new sheet is created. Essentially I
So I have the following code that works correctly and uses a column with URLs to add the images to the next column. The problem being that if you send it to so
I want to count the results of a FILTER in excel. Usually I do something like IF( IFERROR( SUM( FILTER( range, condition)
So, I have a bunch of old .xls files that I want to convert to .xlsx files for the sake of disk space economy. Doing it one-by-one is out of the question. I see
I need to change the lookup_value of RC[-2] with the address Cells(3,2) on the macro code below. Range("D4").FormulaR1C1 = "=VLOOKUP(RC[-2],'[Reference Workbook
the following code causes runtime error '1004' Method OnKey of object '_Application' failed! Any suggestions? Sub MyAchieve() Dim col As Integer Dim row As