macro

Hi Experts I have multiple tables on one sheet. The following Macro works fine on the first table of the sheet. But when it comes to using it on the any other table of the sheet, it misfires. Please help Thanks a lot 🙏 Sub GoTableLast() ' ' GoTableLast Macro ' ' Call GoHome...

Hi, I'm trying to find a macro code to hide/unhide certain/selected cells only using the checkbox. For example, if I tick the checkbox, it will show cells "A4:D9" but when I unchecked it, the mentioned cells will be hidden. Attached is a sample of my query. The shaded parts are the ones...

Greetings excel community, I have some cells that contain a zero and I would like to replace the zero value with the value from the preceding row (the cell above). I saw a formula online which is as follows:=INDIRECT(ADDRESS(ROW()-1|COLUMN())). However, I would have to copy and paste this value...

I've got a macro below, row 2 is the heading (in a table), and I'd like to (in priority) filter I2: select the criteria UP, DOWN, LEFT, RIGHT, sort Z-A (descending). Then filter J2: sort Largest to smallest The macro is able to filter UP, DOWN, LEFT, RIGHT, but doesn't seem to sort from Z-A...

Hi all, I have an excel workbook called Bill of Materials (BOM), which contains a lot of macros and I have always had buttons call certain macros. My BOM excel sheet basically uses power query to organize data sourced from a workbook called Masterlist and throws it on a new sheet (on the BOM...

I have recorded a Macro to re-arrange my table with color and to sort row by date Ascending but later I needed to add 03 rules to remove all filters in the table to show all data then to go to the last row in table and to save the workbook but it seems that they need to be set in a professional...

I have this line of code that I require an excel macro to type out, and drag and drop down. =IF(AND(E3>C3,G3>E3,F3>D3,H3>F3),"UP",IF(AND(C3>E3,E3>G3,D3>F3,F3>H3),"DOWN",IF(AND(E3>C3,G3>E3,D3>F3,F3>H3),"LEFT",IF(AND(C3>E3,E3>G3,F3>D3,H3>F3),"RIGHT","NO")))) Recording an excel macro it turned out...

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