macro - autofilter

Hi All I am using the excel for the work ticketing system register and in process to improve my system I am looking to implement flows. However my document is xlsm and flows will not work on macro documents. The only reason I am using macro is to auto filter upon the opening document...

Looking to filter dynamic data set (1 filter), update 2 columns after filter, AutoFill to all filtered cells in both columns. Filter status column for "X" & "D" Update "qty" column to 0 Update comments column to "gone" code status qty...

I am using the ActiveSheet.Unprotect and Protect codes at the beginning of all my macros, there are 4 total in my workbook. All of them work, except the one AutoFilter code I have to clear contents of table rows based on 3 different criteria. For some reason, I get an error when it filters to...

Hi All This is my first post so hopefully I can give you all the info that you need to assist. I currently have a workbook with four different sheets. The main sheet (Sheet 1) where all the information is gathered and populated to the three others (sheet 2-4)that have slightly different...

Hi to everyone! I created 2 custom toggle buttons with Office RibbonX Editor. So my question is hot to connect them - i mean when i toggle one button - other one should be untoggled. Here is some code from Office RibbonX Editor: <group id="customGroup4" label="Фільтрація за датою">...

Hello everybody, I'm having trouble changing my Macro's colors when it automatically selects fields. Does anyone have any idea how I can solve this problem? Thanks for listening. This code VBA i'm use: Sub RemoveLeadingSpace() Dim Rng, WorkRng As Range On Error Resume Next xTitleId =...

I would appreciate some help with this problem: I want to be able to make a table of n entries long where n is the length based on some cell value. Example. If I want a list of 60 items, I want to be able to type 60 in one cell and then it generate a table 60xm (where m is a predetermine value...

Hi everyone, this is my first post and i new in vba. i create 3 macros for a excel template, that get the data from the first sheet ("Dados") and do some filter in this data in the other 3 sheets. I upload this file in a internal system, that will use this template for download the data from...

The intended effect: The code filters the table (Table1) on Sheet("AutoCensusReport") according to the EditLine# autofilter conditions. Then, if there are any rows that ARENT hidden it selects the unhidden cells that aren't blank in range A and pastes them in the first empty cell in range A on...

I Use a 1200 line module code for 22 commandbutton. when click each one of button, it fulfill 10 cell value. But it is too slow. is there a way to optimize code? this is one of 22 button code: Sub Iron_Condor() ' ' Iron_Condor Macro ' ' Range("R38").Select ActiveCell.FormulaR1C1 =...

Hi Gurus, Do you have any VBA codes that I can use to shortcut the name name. Example: Tab 1 ABC Management ABC Mgmt. ABC Retirement Company ABC Ret. Co. ABC Corporate System ABC Corp. System In Tab 1, I have the raw name (column 1 above) while in Tab 2 I have list of of name and its...

Hi, I'm trying to figure something out with a macro that I'm working on. I'm not very experienced with macros but I'm figuring it out as I go, and what I want to accomplish is working EXCEPT when the source table doesn't have data for a particular filter. Here are the details (with fictional...

I have a worksheet I am trying to create a filter for. I recorded a macro with all of the filtering set to what I need. When I try to assign it to my ComboBox and run it I am getting a Run-Time Error 91 Object variable or with block variable not set. It is highlighting the section "...

Hi all, On Sheet2, I have a drop down that changes the work week to display that week's bookings. On Sheet4, I have an "Override Tab" where the users can input their weekly forecast and any corrections to the bookings. What I'm trying to do is get a VBA autofilter on Sheet4 that activates rows...

I currently have multiple sheets for storing records of payments (things to be Pay and CantPay). I am trying to write a macro that will copy and paste Cells A:M on every row where column T = "Resolved" on the CantPay sheet (where the next empty row is the next row where "a" & row-number = blank)...

I have a spread sheet that gets populated with data from a number of source text files. That text is then stripped down to the relevant data and collated into columns on another sheet (sheet 2). I now need to copy all columns that meet a certain criteria to a third sheet. For example, if...

I have the below macro created. It cycles through all sheets in a workbook, except for X, Y, and Z. For each sheet it takes the value in cell A1, and filters sheet ABC based on that value. Then it selects the displayed values from columns A through S on sheet ABC, down as far as row 100, and...

I'm trying to create a macro which allow me to remove a row if it contains an exact word. When I extract data, the column may contain the word "Renewal" or "Renewal & Additional". What I'm trying to achieve is to remove all the rows that contain the word "Renewal" and not the rows that contain...

Hello, I have added the code to filtrer by pressing the button under the filter column and it work. However, I need to be able to do more than 1 filter. IE: Cell b1 and b2 is from invoice # X to invoice # X -> click on the filter button = filter only these invoices. Cell c1 and c2 is from...

HI All I am trying to setup a FIFO (first in first out) sheet for stock. Ideally I would like to have 'CTRL+G' as the short cut to run the macro (currently set to a button). the issue I have is keeping the dropdown list within the ranged cells. my current macro deletes everything, so formulae...