Recent content by greykitten

Thank you so much for your quick response Hui! That was very helpful :) ~ greykitten

Hello Forum, I'm very new to VBA and struggling with how I alter a macro to apply formatting when the number of rows changes from month to month. I used the macro recorder on a very simple example and I found the following snippet below to find the last row. But I'm not following where I add...

Hello r2c2, Wow, this is amazing work! It works perfectly except for two things. 1) I also have data in columns N - AS. I can't figure out what to modify in the macro to copy data found in columns N - AS in the same way that columns A - L are copied. Would that be done by changing the range...

Hello Forum, I just discovered VBA and I'm trying to write a conditional macro where VBA will add (x) number of rows depending on how many separate numbers appear in a specific cell. However, I can't find any postings that specifically address this scenario. I've attached a generic and...

Hi John, Do you know how I could adjust that formula to count the number of times that those three values appear that column? I tried this =COUNTIFS($A$2:$A$23769,{"EWS Duplicate Detection";"EWS/ANF";"EWS/RNF"},$J$2:$J$23769,"Closed") but it produced a small number nowhere near the real...

Hello, I'm trying to use a SUMIF's formula to calculate a sum if a column contains the following values, "EWS Duplicate Detection", "EWS/ANF" or "EWS/RNF". I'm not sure if the SUMIF's formula is the right one for this because SUMIF's require that all conditions be met. The formula needs to...

Thanks so much Luke! :)

Thanks Narayan. That format produces "$88.05K" when I try it. What would I change the custom format to since I just want "$88K"? What if I wanted "$88.1K"? I tried adjusting the custom format but I couldn't get it down to just "$88K". Thanks again! GK

Hello, I'm trying to take the difference of two values, divide that answer by 1000 to make the answer more readable and add a "K" to the end of the number to denote the number being in thousands. The answer should look like "$88K". Here is a general example of what I'm trying to produce. I...

By the way, this summed the entire column which was incorrect. It didn't achieve the goal of filtering by types B and E for items sold from 0 to 30 days.

Thank you eibi! :)

Hello, I'm having trouble with a SUMIFS formula where I need to return a dollar value for a range between 0 and 30 days and if the customer type code is either B or E. I've tried using this formula: =SUMIFS($B$3:$B$27,$C$3:$C$27,"0 to 30 Days",$D$3:$D$27,"B")*OR($D$3:$D$27,"E") but it isn't...