loc

  1. L

    Match multiple values from one column with single value from other column

    Dear MrExcel community, greetings! After thorough searching through forum, I could not find an answer to my needs (maybe I didn't search properly?) I have a following issue: I have a LOC column that has unique values (locations) and GRADE column (which has only 4 possible values). My...
  2. H

    Macro Issues - Search for call value in a range

    Hi All Can someone please help with my issue. Basically I have a workbook that has a Template tab, Home Page tab, Reports tab plus mutiple project tabs with different names. On the Home Page tab I have a search box where I will enter a project tab name to search it in the open tabs. The code...
  3. D

    Compile error

    Hello all, I'm attempting to write a script to open up the most current Excel spreadsheet once it has been placed into a specific folder. I've run into a compiling issue when I attempt to run my code. Sub OpenMostRecent() Dim fs As String, ws As Worksheet, i As Long Dim loc As Long...
  4. S

    sumifs with 2 sum ranges

    <tbody> Products Source Actuals<strike></strike> Plan a Loc 40 50 b Imp 50 30 c Imp 10 20 d loc 10 20 </tbody> Actuals Loc a Please share formula in cell A9 from the array A2:D5 with meeting condition in cell A6, A7 & A8. In other words I am not able to find 2 sum ranges in SUMIFS...
  5. P

    Trying to update one or group of cells on change with VBA

    Hello, I am trying to update when users change one or group of cells within a range when there is a space to replace with an underscore. It is working, however with a group a cells, perhaps like copy or control enter, the values only update after you click on each cell. Works okay when one...
  6. Z

    How to change VBA formula to value

    Hi, I have below VB formulas and I need to turn each formula to value, can anyone advise how? Range("AA18:AA42").Formula = "=IFERROR(1-(AD18/AC18),IFERROR(1-(AD18/AC18)," & Chr(34) & Chr(34) & "))"Range("AB18:AB42").Formula = "=IFERROR(AD18/AC18,"""")" Range("Z18:Z42").FormulaR1C1 =...
  7. Z

    VBA Formula

    Hi, I have below formulas and I need someone to help me writing it as VBA formula: =IF($Y$16 = "by Loc", INDIRECT($AC$14), $Z$15) =IF($Y$16 = "by Loc", IF(ROW(INDIRECT($AC$14)) + COUNTA($Y$18:$Y18) > ROW(INDIRECT($AC$15)), "", OFFSET(INDIRECT($AC$14), COUNTA($Y$18:$Y18), 0)), IF($Z$15 +...
  8. M

    Excel VBA InStr Function to delete string of text within a cell

    I have a strings of text similar to the following (4010059877-TUR36036133 or TUR603916## 401007329) in column "AK".I need to Eliminate the TUR######## which can be at any point in the cell and has a different number behind it each time. Is There a way to delete only this part of the cell? I...
  9. T

    cmd /c del to delete file

    I want to use the cmd /c del command to delete a file, instead of Kill. This works: Dim Loc As String Loc = "C:\MyFolder\abcdef.xlsm" Dim cmd As String cmd = "cmd /c del " & Loc Shell cmd but if the filename contains a space like this, it fails...
  10. S

    3 condition sum formula

    Please help I need formula to bring result in cell A4 based on the change condition in A1, A2 & A3 from the array B1:F10. <colgroup><col width="64" style="width:48pt" span="6"> </colgroup><tbody> A Area Source Jan Feb Mar Jan A Imp #FFFF00[/URL] , align: right"]1 2...
  11. D

    How do I open a non excel file from within VBA?

    Hi all, So I'm using a userform to open a particular file via a vlookup from 2 combobox inputs. However, it won't work with non excel files. Can anyone help me with this? I use the following code: Private Sub OkButton_Click() Dim loc As Variant loc = Application.VLookup(Me.ComboBox2.Value...
  12. I

    Macro Problems

    Hey guys my code below works only partially.. basically whenever it wants. For the first part of the code where it looks for dilutions (ie x5 x10 x20 x2.5) it doesn't recognize decimals.. Can the string value be changes to recognize that? For the C1 part of the code: Seems to never c1 if one...
  13. K

    PivotTable Sort Multiple Filters Per Field

    I have the attached data. I am trying to sort column F from largest to smallest but after the Month, LOC and then Disch Service. Please help.
  14. P

    Looking to see if possible

    I am trying to return the text in a column, when the value in another column is greater than 0 for any entry matching a value. From below I need to write the Loc of each bin into the cell with ??. <tbody> Item Blocked Loc X 123 ?? </tbody> <tbody> Item Blocked Loc A 1 S X 100 H B 2...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top