code

Hi all, I have this formula: =IFERROR(SUM(IF(FREQUENCY(IF($A$2:$A$101=A2;IF($D$2:$D$101=D2;IF($H$2:$H$101=H2;MATCH($I$2:$I$101;$I$2:$I$101;0))));ROW($A$2:$A$101)-ROW($A$2)+1);1));"0") It checks the following sheet (please note that A2, A3 and A4 have the same value): ' I want the formula to...

Hello, I have the below assigned to filter buttons which automatically filter a list, based on the criterial. For "office" I also need it to filter "call centre" in addition. So when the "office" button is pressed, it also filters call centre with office. Sub Office() ' ' Office Macro ' '...

Hi! I have been using a VBA code for copying .pdf files from a folders (please see code below). I want it to skip folders with "working" or "~superseded" on the folder names. I've read about the InStr function but I can't figure out where to place it in this code. Thank you so much for your...

Is there a way to change a cell color and add text to a specific cell if condition is True? Ex. I have cell A1 that contains values of either True or False. If A1 is True, I want B1 to change to black and Display "Pass" in white font with the text size of 20. I was wondering if this is...

I have created an excel spreadsheet showing a list of inventory. I wanted to be able to put an X in the final column to provide an easy move to the out page. This will let me know when thing are taken out of the warehouse. I have created both worksheets. I even got the code and them up and...

So the picture below is of a sheet of data and i want to put a section of code in a macro that i already have that would export all rows with unique manifest numbers to a pdf file before the macro deletes the data on this sheet. The macro that i already have copies a selection from the 2023...

Hi all, I have an open workbook with three sheets called "1", "2", and "3". I want to hide these sheets and make it so that you cannot open or view them without a specific password. Right now, I can protect these sheets. However, protecting them means that you can still click on the sheets...

Hi there, Hoping someone can help me with the following: I have a yes or no dropdown in cell J13 and would like to hide row 14 if the value in j13 is no. If the value in j13 is yes, I would like row 14 to unhide. I would like to run the code each time the value in J13 is changed. Any...

Hello, I'm tryin to sort values based on colors, then on values The macro was working very well, but on one sheet, so I have to create a new module for each sheet, and because I have around 400 sheets, This is the simple working macro: Sub A_Sort() ' ' A_Sort Macro ' '...

Hi Folks. I have a routine that is supposed to look for blank cells (after there is a subtotal placed on the data) and fill them with data. My problem is sometimes there is only one subtotal so that leaves the 'filling in the blanks' problem mute. My routine doesn't know how to handle that...

Hi, I have the following code which creates an array "Ary" with string elements from a table column that match value "x" from another column in this table. I would like to have cell E6 display a randomly picked string element from this array "Ary". How would I have to alter the VBA code? Sub...

Hello, Excel Wizards, I have an excel file where I have some VBA code to create a checkbox in column B, everytime I add a row to a table. But this code is not finished and I've been trying to improve it, but my knowledge in VBA is really limited. So, my code is creating the checkboxes in...

I'm currently using this code and it works but the images will not show up if I give the file to someone else PictureLoc = "C:\\test\active" & Range("A2").Value & ".png" I need it to grab the image from another sheet on the same workbook like sheet2 I tried this but it didn't work PictureLoc =...

Hi all, I currently have this graph: I don't really care about the light and dark orange columns, but I need them to stay nonetheless. However, the grey chart rises from a value of about 9300 to 10500 doing this period, which is not that noticeable in this chart to be honest. I would like...

Hello, Really silly question but I have no idea how to do this: I need to add these two: Me.Protect Password:="zzz" Me.Unprotect Password:="zzz" Into the below, so I can get the below to work on a protected workbook. The ZZZ I will amend to the protection password later but it basically...

Hello, The code below is not working properly: I can't understand how this is happening, as I have another workbook laid out the same with exactly the same code in it and it works perfectly. I'm not an advanced user at all, someone on here kindly put it together for me, so I have no idea how...

Hello I have the below code which moves a row of data to another sheet based on a value selected from a list. When the list item is selected, I'd like the row to be moved to the "LTS" sheet with all conditional formatting removed. Is this possible? Private Sub Worksheet_Change(ByVal Target...

Hello Board, I have the following question on VBA. I have a large excel with 100 different tabs which currently includes many hardcodes. The tabs have the exact same structure which is helpful so you can always pull up the same value from the same place. I have created a new tab which will be...

Hello, This is my first post and I am a moderate newb at writing VBA. I am struggling with overwriting existing cells...... Here is my scenario Excel file with different worksheets for each state in the US (50+) I have created 3 worksheets within the file so I can be able to have the specific...

Hello all - I am in need of assistance. What I am trying to do is create a code where I click on a checkbox using an Active X Control Checkbox and it only displays information in that column. For example, if my spreadsheet has "GM", I click the check box and the only column that appears is "GM"...