code

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

Wondering if someone can help me with the below code. I got made redundant from a company and saved this code for use in the new job. It worked at the previous place but now, oddly, it's saving PDFs with the file extension ".22" (a 22 File). Never seen this before.. The idea of the below is to...

I have a macro that will identify whether there is any value in a specific cell in each tab. If it is blank, go to next tab but if there is data, delete all data and go to the next. The issue I am facing is that the code below will delete only the data set but leaves blank rows (checked by...

Hi all, I have this file that was converted from PDF to Excel. I would really like to filter everything in column A by date However, when I do it looks like this: It filters down until row 687 The row looks like this: I have no idea why it stops? It used to stop at points like these...

Hi all, I am very rusty in Vlookup (embarassing!) and I am currently looking at this data: I would like to create a formula that checks the same date in column A, as checked in column F and then tells me whether or not the value for this date is also present in my data set in columns F-G. I...

Hi all, I currently have a data set that looks like this: The issue for me is that it is currently stated in a format of "Month-Date-Year". I would like to replace this with a format of "Date-Month-Year". Does anybody have a nice solution to this, for example a formula as illustrated in my...

Hi all, I currently have a very large data sheet that looks like this: In this example, I've just put in a format of: Date,Name,Gender Please note that some of the cells however might only have Date,Gender or Name,Gender or Date,Gender etc. My ideal format would be: Date,Name,Gender...

Hi all, I am currently working with a data set that looks like this: I would like a formula that takes all the values in column A, and if they begin with a comma (","), it should remove this So the result should be like this: Does anybody have a formula for this? It would be greatly...