macro

Question says it all. I cannot figure out how to automatically populate the print area / print tile section by referencing 2 dates. I’m using pay period dates. Start date is in cell A2 and end date is in cell B2. I need a formula to find these exact dates within column A, then return the...

Hello! I've tried everything here and I hope you folks can help me. I have a spreadsheet with several tabs. On each tab, I've defined a named range for the tab. For example, on my Sales Sheet tab, I have the named range called SALES_SHEET. I also have Additional Pages-1 through -8...

Hi expert, I have a data table with 3 columns. Column 1: Type of product(Part or Unit). Column 2: Location . Column 3: Block. as image below: Column 1: Defind name: Part /Unit Column 2: Location to located part/unit in sheets Column 3: The block column will show which items are assembled...

Hi All, I would like a to get a VBA code that, once I press it, looks at cell D5 and then copy pastes the formula from BW34:BW36 to BX34:BX3, as well as from BX41:BX50, because cell BX6 is >= 2. The next month, when cell D6 is updated to the number 3, it should update column BY as well. Please...

I have a table starting in row 2 (heading in row 2, data starts in row 3), and I'd like to filter in priority: In column I - select the criteria UP, DOWN, LEFT, RIGHT, Then column J - sort largest to smallest Then filter out #DIV/0! from column J Then back to column I - sort Z-A (descending)...

I've got a table, and in Column J, starting from J3 going downwards, I'd like to filter out all the values which are #DIV/0! I tried recording a macro and this is what came up below, but the end of the table (J1050) sometimes changes (could be more or less), and also it seems to be including...

I am new to macros/VBAs so I'm looking for help in writing this code. I have a spreadsheet that is used as a data source (SourceFile), which contains data in Columns F, H, and I. I would like to copy the entire column of all three columns and INSERT them into multiple workbooks that are saved...

I want to make a button and put it on a cell so that when I click the button that cell increases by 1. Easy enough; Developer tab -> Insert -> Button - >Place on correct cell -> Assign Button the macro below. Sub AddTally() Range("G9").Value = Range("G9").Value + 1 End Sub And it works...

I have a macro to save the workbook into pdf that is currently "running" but deleting a sheet that I do not want deleted. Here are the steps of the macro. 1. Make the necessary tabs visible. - Works 2. Unprotect workbook. - Works 3. Create a copy of a tab for each varation of a value in a drop...

So, I have macro-enabled templates for office use. I found a VBA code to KINDA address the problem I was having. Not everyone here is very Excel savvy, so I know they wouldn't be able to remember to save the workbooks as macro-enabled workbook. I found the code for that: Private Sub...

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