desperate

Hello, I am using a macro filtering with a "X" in a certain column and pasting in on another table, I need to do it on repetitive way with different filtering column. It works until a certain column, then the macro is not going forward. I have first a macro defining a format for the subject...

=SUMIFS(INDIRECT("'"&$C$3&"'!h2:h365"),INDIRECT("'"&$C$3&"'!c2:c365",G3),INDIRECT("'"&$C$3&"'!d2:d365",A13)) This formula returns a value of '0', instead of 40 When I remove the indirect function, i.e =SUMIFS('2019'!H2:H365,'2019'!C2:C365,"="&G3,'2019'!D2:D365,"="&A11) I get the value 40...

Hello All! Please forgive my complete lack of inexperience. I have never taken a class on writing excel macros and have so far been able to piece through what I have needed to do by intensive google searching, but I can not seem to get this code to work. When I hit play it doesn't actually give...

Hi, Im in desperate need of help with this VBA code. The code works fine when entered manually however I need the code to work when linked with a live feed. Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range If Target.Address <> Range("G1").Address Then Exit Sub...

Firstly a massive thank you anybody who is wiling to help me..... my problem starts with information that has been given to me is very limited but should be enough to solve my problem i need to identify how many adjacent structures each structure has, basically there will always be one or up to...

I have been playing around for a while now but no matter how hard I try I just can't get my vba coding to work for what I'm trying to do. I have had some limited success with match and index and then removing duplicates witch seemed to give me almost what I needed. Ok so this is what I'm trying...

Hi Excel VBA Gurus! H.E.L.P. P.L.E.A.S.E Am new here and hope someone can help, I am literally pulling my hair out. :confused: I have searched and searched and not come up with a solution and cannot explain what is happening. Basically I have a worksheet in Excel 2013 (on a Win 7 X86...

Hi peepz, I am really in need of desperate help, I have been trying to find the answer for my question the last 4 hours and haven't got any closer to a solution. The problem has to do with an unexpected change to a small in size "less than 3 mb" but very complex workbook which normally...

Hi, I have a table of data that includes dates in L2:L6000 in the dd/mm/yy format. I am trying to run a macro that will filter the dates in column L between two variable dates. The variable dates are in cells AG18 & AG19 in the same format. I have been struggling for hours with half dozen...

=IF(E5>0,E5+D6,0) how can have this add and subtract

Hello, I am currently creating an annual leave formula for the company I work in and I need help. I have created 4 headings <TABLE style="WIDTH: 195pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=260><COLGROUP><COL style="WIDTH: 51pt; mso-width-source: userset...