macro - column

Dear All, I've been passed a Macro to delete values after the highest within an array of values in a column. Now I'd like to do a similar operation, but deleting the values preceding the lowest. The Macro I use for delete after the max is the following: Sub deleteaftermax() Dim i As Integer...

Hello! I have prepared a document in which about 50 volunteers must indicate their availability on certain dates each month. The columns in which they indicate yes or no should always open for editing, for anyone. In contrast, columns A through L contain information they should never be able...

I have a long list of strings in a1 but I want to extract the numbers from the strings. Additionally some of the strings have special character aside from just the alphabet that I also want to remove. Is there a macro that exists that will delete the entire uppercase and lowercase alphabet from...

I'm trying to building a macro that will look in column A for certain wildcard values and delete any row that contains them. The values I need to find in column A and remove the row for are: *claims, applying, startig (yes this is a typo but the report comes with it like this). Also the...

Hi, I've got a massive report that has locations by time period going across the top. It is a huge manual task when I need to add a new time period. As shown in my image below, I'm trying to add a new column for 2025, and then want to copy and paste whatever is in the 2024 column to the new...

Hi Gurus, Could you help me simplify below code which I recorded? Basically, I need to apply these conditional formatting and hoping that the macro will look for Change 1, Change 2 and Change 3 header name and reflect the number format for all tabs (as the column might interchange on the other...

Good Afternoon, I hope someone will be able to help me with following situation Im working on a file with a lot of data. The macro used was working perfectly until recently. Im not the one who created it and I don"t have many knowledge on Macros... The goal is to have the price in column S...

Hello, I have a worksheet where I am inputting general criteria for a project at the top, and the bottom rows are different tasks based on those inputs. Specifically, Cell C9 inputs the project type. The rows below starting at A15 include different tasks based on the project type. I want a macro...

I have two Excel sheets with named : Patching_MainSheet and ESL_Inventory In Patching_MainSheet D column have 100 Servernames and ESL_Inventory Sheet A Column have 1845 Servernames and also I column have DataCentre name. I need Macros to take one servername from Patching_MainSheet of D...

Hi there, I have several macros which have been written individually which run simple formulas and return the data to the active column. Eg. Macro 1 enters a simple formula in cell X2, to return the result, whereby column X is the first blank column at the end of my dataset. To avoid running...