macro

  1. G

    Formula or macro to retrieve cell above to replace zero

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

    Sort (Z-A) Macro not working

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

    Cannot assign macro to button

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

    Retype Macro to run properly

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

    Typing out Excel formula in Excel Macro

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

    Seeking Code / Macro to Edit Row Height

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

    Combine input box (multiple criteria)

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

    How can I create a button to insert a new row and update related formulas?

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

    Macro for

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

    Return error if "Filter" doesn't return the required entry

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

    VBA Coding for adding Pivot Table with changing data table

    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 ' '...
  12. N

    Help with creating a 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...
  13. S

    Auto protect certain columns after 5 minutes inactivity

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

    Splitting Ranges of Data Apart

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

    How to run the same macro separately in all worksheets

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

    Macro Coding Help

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

    Accessing a named range to insert a value does not work

    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 =...
  18. S

    Finding Largest 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...
  19. S

    Copying value when cell value changes

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

    How to copy a worksheet and update a cell showing the date in increments

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top