apply

I have a macro based on a page here Sub Gen1() Range("A4").Select Selection.CurrentRegion.Select Selection.AutoFilter ActiveSheet.Range("$A$3:$AF$117").AutoFilter Field:=3, Criteria1:="1" End Sub It works great. However, my table of data is constantly growing. I'm struggling to...

Hi, In cell K33 i have pasted the following code. =SUM('INCOME (1)'!G32 -'EXPENSES (1)'!K32)-MILEAGE!C32 When i then hit enter *** opposed to see the code apply itself & return a value the browser tree opens and advises me to update value income 1 Whats happening ? Thanks

Hello everyone, im sorry if i dont express myself in the best way or if this question is already explained in full detail on the forums, is that i am new to VBA and excel macros (self-learning) and someone you dont know the names of stuff so when you search for it you might not find what you...

Hi to everyone, i have searched around to find the specific macro that i can use to solve my issue but nothing works, so i need a modified macro to help me get cell values from multiple files in one folder C:\workbooks (.xclx) the concrete cells i need to get data from are A1 E59 E60 etc. (i...

Hi all, I thought this would be a relatively easy conditional format to apply however i'm really struggling to find a solution. In brief I would like to apply a conditional format to highlight cell A1, if any of the cells in range, say A2:A100, contain any text. (A2:A100 should only contain...

I have rows of hourly power data that I need to sum to apply 2 daily charge tariffs. The time date output is in the format 01:00 Mar 08 2018. How can I apply a sumif to add consumption in 2 blocks for each day? the time periods are 07:00 to 19:00 & 19:00 to 07:00 ? The data is downloaded in a...

We use alternating background fill color in columns A-G as a visual reference to distinguish between rows with certain payroll date values stored in G. Currently, we have 2 macro buttons that each apply 1 of the colors. I'd like to incorporate this functionality into the vba language, so we can...

Hi, I need to apply two data validations in a single cell. One is the name and other is a text 1) =validation_customers (This one is a named range) 2) ALL (This one is a simple Text) I would like to know how to apply these two in a single cell. Any help would be appreciated. Regards, Humayun

I have a worksheet with 747 rows of data. In column E, starting with E3, are times that have been converted to numbers (e.g., 11:00 is 11.00). I need to convert all the numbers to times but when I try TEXT, I get the wrong result. In E3 is 11.00 and when I apply =TEXT(E3,"H:MM"), I get 0:00...

Hello, I have a worksheet containing 12 columns (January - December) and 75 rows (various products). I want to conditionally format each row to highlight price evolution (ie if product X is $20000 in Jan, then $22000 in Feb, highlight red, if $19000 in Mar then highlight green). I can...

I have several VBA macros which i hopeful of adding only a 'delete leading and trailing spaces' to. i apply the macro to different size files, with different row and column lengths. What i'm after is a code that will apply specifically a 'delete leading and trailing spaces' to what i...

Hello Gentlepeople occasionally I want a deeper view into duplicate values. I want to see not only what is duplicate, yes or no, but also which duplicates tie out. I apply the conditional format for unique values to make the cells look normal and then the next rule is to apply the color scale...

I am trying to use sumif =SUMIF('Sales'!$A$1:$A$15237,'Monthly'!A1,'Sales'!$D$1:$D$15237) The problem is that the data in Monthly A1 is text written as yyyy/mm which I cannot convert to a value unless I use something like RIGHT or REPLACE: =RIGHT('Sales'!A1,1)+0 or...

Hello, I'd like some VBA worksheet change to apply borders that applies to a range when data is entered. So, For examples data is in B12:AB700. But at present data is only up to row 125 so should only apply to this. Any ideas? Thanks.

Private Sub ComboBox1_Change() ActiveSheet.AutoFilterMode = False ActiveSheet.Range("c3:aa3").Select Selection.AutoFilter Range("C3").AutoFilter Field:=1, Criteria1:=Sheets("sheet3").Range("d3").Value ActiveSheet.Range.Offset(0, 24).Select End Sub above code don't work as I am trying to apply a...

Hi I wonder if anyone can help? I want to automate filtering by applying a macro after inputting a value in a cell, the value of which I would like the filter to apply. While I can automate the cell value by using Combo boxes and I can apply a macro of my choice, I do not know how to link a...

Hi, I was reading about how good etc Bat files were. I see you can have a button which would run a Bat file. Just how good are they ? Running a Bat file would it be able to apply a hyperlink to the number in the active cell. Obviously the path to where the files would be kept would be...

Hi People, I have purchased a digital certificate from a company called GlobalSign to sign my VBA codes (Excel). They sent me a USB (eToken) and helped me to install the certificate on my computer. However, the rest has become a nightmare for me. The problem is that I don't know how to apply...

Hello ! So i want to apply a macro to a column, but it may change the column from user to user. So, i thought, if the user could indicate for what cell he wants to apply the macro, it would be easier. But the problem is: 1. I have the macro i want to apply. 2. I have the button 3. i Don't know...

I have a template sheet called "template" that I'd like to apply to all sheets starting on the 4th. How do I loop through each sheet, apply the format and do some other functions. I posted a macro I create to do it manually. But it needs to dynamically take the value in A9, paste into the range...