Hi David Frankly I have never liked creating Pivot Tables using VBA but this one just for you. Just run the macro named ConsoleData Good luck...
Hi Stefi It sounds like you need an IF() function. Without seeing your expected results (with different scenarios) we can only make a guess. ...
Hi Jonathan Thanks for sharing. You can also use SUMIFS to get the result you want. From your example, there can be as many as 6 Quarters (you o...
Hi David Your data have a lot of duplicates and need to be consolidated before any comparison can be made. Furthermore the PO# and Item is Text ...
Hi David It is very unclear what you are trying to achieve. What are you trying to compare? What is the expected result from the comparison? etc......
Hi Rachel I believe you wanted to only sum values where the cost type is Staff costs (direct and external). If that is the case, then you can us...
Just add this line before the End Sub Sheets("Result").PrintOut or if you want to preview then Sheets("Result").PrintPreview Just make sur...
Hi Lea In cell D2 enter =VLOOKUP(SUBSTITUTE(SUBSTITUTE(A2,"-0",""),"(---)","")&"*",C:C,1,FALSE) Copy down as many rows as needed. What...
Hi Crystal Just copy the formula in cell T2 =IF(S2<15,"under","") downwards to as many rows as you want.
Hi Rachel It is better if you could attach your file with some sample data and the expected result. It will help us to understand your needs bet...
Hi Vic No problem. Sunny
Hi Bahram Give this a try. Please note that I am using Advanced Filter with VBA. You can refer here for more info on Advanced Filter I did no...
Hi Kavin, welcome to the forum. Give this a try. Sub DelRows() Dim LastRow As Long Dim i As Long Dim ValToCompare 'Value to compare ValToComp...
No problem. Glad we are able to help.
Try this then =COUNTIFS(S:S,">=15")