desperate

  1. L

    Issue in my macro

    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...
  2. C

    Desperate for a solution

    =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...
  3. D

    User form to Search for and Update Data

    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...
  4. B

    In desperate need of help!

    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...
  5. R

    Brain teaser, VBA code needed to prevent insanity, vlook up index and match

    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...
  6. R

    Brain teaser. Please I need help anybody. My vba coding nightmare

    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...
  7. Mr Boris

    Excel 2013 - VBA - Runtime Error 9 when creating & accessing [more than 4!] Conditional Formating Items - HELP PLEASE!

    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...
  8. B

    Excel re-calculation for almost entire sheet when changing content of empty cell

    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...
  9. W

    Macro autofilter problem

    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...
  10. S

    "if" formula

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

    2010 Holiday Form - Formula Help

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top