everytime

how can i change the code below to activesheet instead of referencing sheet name so i can use in other sheets and don't have to change sheet name everytime. Sub ApplyFiters_Accrued()With Worksheets("OCT").Range("A3") .AutoFilter Field:=5, Criteria1:="" .AutoFilter Field:=9, Criteria1:="COGS"...

Need help in automating the formulas the reference row needs to move by 18 everytime. Could someone please help Thanks

Need help in automating the formulas the reference row needs to move by 18 everytime. Could someone please help Thanks

Hey Guys... How can I add a break line between when a new set of numbers appear... <tbody> Date Post Track Racenum 3/20/19 16:00 CT 1 3/20/19 16:00 CT 1 3/20/19 16:00 CT 1 3/20/19 16:00 CT 1 3/20/19 16:00 CT 1 3/20/19 16:00 CT 1 3/20/19 16:29 CT 2 3/20/19 16:29 CT 2...

Hi All, In Column D of a sheet I enter a Charge Reference, for example CL12346. This relates to an Authority which I put in Column I. What I would like to do is everytime i enter a new reference it will put the appropriate Authority in Column I. I have worked out the code for the Lookup...

Hello Everyone, Need some help with the following hoping someone can help with this. I have A, B, C Columns where A1 have a date such as 9/1/2018 where B1 have a number such as 5 and C1 have a formula which is =A1+B1 , so I can see the final date. What i want is everytime A1 changes, I would...

Current Code: Sub Chart_Toggle() If Worksheets("Inputs").Range("F74").Value = 1 Then Worksheets("Structuring").ChartObjects("Chart 3").Visible = False ElseIf Worksheets("Inputs").Range("F74").Value = 0 Then Worksheets("Structuring").ChartObjects("Chart 3").Visible = True...

Hi, I am trying to select all sheets with the name assembly. What happens is it selects all sheets with the name Assembly, assembly (2), assembly (3), etc. Then it adds a color to range T13:U21 based on the value in another sheet. But Everytime I try a different code, it only applies to the last...

Hello thanks for taking the time to read and hopefully help me out. My question sounds simple (to me) but i have a worksheet with word files on it that other sheets will later have links to, to edit and print. However I want the file to remain fresh everytime it's opened. Currently everytime I...

Hi, Wrote this code to run and format three series everytime a pivot table updates. With three series I am formatting the colours of all three and the making the third series a secondary axis and a line chart. What am I doing wrong? the macro is not running everytime I select a slice Sub...

Hello There are about 50 textboxes in the userform i created. Everytime time i added a new textbox, I have to re-order the textbox to textbox1, 2,3,4...and so on. I have to do it each one everytime i added a new one. Is there an easiest way to set the textboxes in reorder all at once? Thanks

Hello, I notice that everytime I bulk tried to find & replace the hyperlink inside a excel cell, once hover over or clicked on the link it will show the old original outdated link, I was wondering how can I have the new one to show everytime. Below is a example of what I'm referring to.