macro

I piece together weekly reports for my team. I keep row heights at a minimum 75.00, 100 pixels and maximum 203.25, 271 pixels. To take a lot of time out of this task and make it automated, I would like to conditionally format (though probably not possible based on my research) or enter a code /...

My original excel macro is here, where I have to manually go into the excel macro to adjust the values If a(i, 1) <= 0.3 Or a(i, 8) < 30 Or a(i, 11) < 50000 Then b(i, 1) = 1 Option Explicit Sub Delete_Rows_Multi_Criteria() Application.ScreenUpdating = False Dim ws As Worksheet Set...

So I have a budget spreadsheet that is a list of values in different sections, a total at the bottom that sums each value in the section, and a overall total that sums all the section totals. If possible I want to create a macro that allows me to press a button and insert a new row into a...

OK, I have a question, I have a survey with a lot of questions ordered in columns. The first line of the column is the question itself and the following lines are the answers from the different participants. I want to have an overview how many times each answer is given (e.g. 5x yes and 2x no or...

I currently have the sub-Macro below which filters for Columns A and B (for Strings Asset and SN), and then copies the value. What I'm trying to figure out is how do I set it so that if no results are found for either, the macro would generate an error instead of crashing/copying just the title...

Hello there, Looking for some guidance on how to code into my macro adding a Pivot Table that has a variable data set. I have the attached coding but does not work if the data set increases/decreases. TIA! Sub BuyerItemPivotTable() ' ' BuyerItemPivotTable Macro ' '...

Hello y'all! I am a noob when it comes to creating macros so I need help from the community. I am looking to make a macro that creates a table in Sheet2 based on the info provided in Sheet1. It must take the info from Sheet 1, Column A (E-mail adresses) and take it to Sheet2, Column A, but...

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...

Hello to all who might be able to assist me and my colleagues with this. I am trying to find a way to split the ranges of numbers apart and to get each individual number that would be in that range. For instance, some of the data I am working with is: 120751.120754 120760.120764...

I have a workbook with multiple sheets and I have a simple macro to go to the last row in the sheet Sub LastRow() Range("amberville").Select Selection.End(xlDown).Select End Sub my problem is that when i copy the macro button to other sheet in the same workbook it doesn't work unless...

I have a macro that I run daily, after the macro runs I manually go and update what I do not how to code. Effectively there is information in a cell of a workbook, Cell G2, always G2. The thing is each week the file name changes by week number and the week number comes from Excel...

0 I have a piece of code that is trying to overwrite the value in a named range, but I am getting <Object doesn't support this property or method> Sub CheckStuff() If Evaluate("Table1RowCount") > Evaluate("Table1LastRowFixed") Then ActiveWorkbook.Range("Table1LastRowFixed").Value =...

I have "Asset ID" in Column A, and "Unit ID" in Column B. See Image of sample data below. I need to find the largest unit ID for a given Asset. I found: MaxSN = Application.WorksheetFunction.Max(Range("B:B")) But this only works if there are numbers - the SN messes it up. I tried using...

I have a spreadsheet in which the user will enter data in Column A. Every time that data is entered, I need that data to be stored as a string "Asset" for additional steps. I cant get this to work: Private Sub Worksheet_Change(ByVal Target As Range) ' Check if the changed cell is A1...

Hello, I am trying to come up with a function or a VBA macro that is able to automatically update a cell with the next days date (based off previous worksheet) on the newly copied shoot Example: make a copy of the current worksheet (Sept 8), but the date in cell B1 updates incrementally to Sept...

I've got 2 macros that would run one after another (A4ResetFormulaOnBlankRow, then A5ClearToRight), but the problem is the A4ResetFormulaOnBlankRow macro runs really slowly when I've got 5000+ rows of data. If there isn't many rows of data, there isn't really a problem, but I'm working with lots...

I don't know why it's not working honestly, I assumed it was in case the cell has no value or is blank and that's why it won't run but I'm not sure. Posting almost my whole script because I'm not sure if it's really the sumValue that is the problem or did I break a rule somewhere: sumValue =...

Hello, I recorded a macro just clearing inputs in my file that I'm working with and I've inserted a button onto the sheet and done the 'assign macro' step but it doesn't run my macro. I'm not getting any error or anything, the button does nothing. The macro works if run it from the 'View...

I need to compare two sheets (Sheet 1 titled Client, Sheet 2 titled Advisor), each with a table with identical column headers and first column. The first column has the property names, and the additional columns have the information Fields about those properties. I would like the Macro to...

Hi everyone, I appreciate everyone who takes a moment to read over the problem I'm trying to solve. The image below is a list of 10 records that equal a total of 4 sets of "Washes". Problem: Humans have to manually identify washes and remove from "Master" Sheet. We currently have to highlight...