loc

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

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

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

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

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

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

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

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

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

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

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

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

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.

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