1. I

    Looping vba code until all relevant data ends?

    Hello. I have this VBA code that identifies route codes in one sheet in a workbook (pickorder). Then in another workbook (CX) it identifies those same route codes and gets the value (times) in 1 row below and pastes it into column A in the first workbook (pickorder). The code works really well...
  2. V

    Unique ID between two date ranges

    Hello, Would like assistance to run a query in Access for the table below, where the ID is a text format. Date ID Value 4/15/2020 ABA 2.00 4/15/2020 NHB 1.00 4/19/2020 BBB 0.222 4/20/2020 RRRf 1.55 5/1/2020 NNN 9.55 5/2/2020 JUY 2.22 5/2/2020 YYY 2.22...
  3. M

    Vlook up between two workbook and display message

    Workbook A,sheet 1 Supplier Amount Owner status Date AVT 500 John 4/22/2020 ABC 1000 Peter 4/21/2020 NAC 600 John 4/22/2020 BAT 10001 Andrea 4/23/2020 Workbook B, sheet 1 Condition should match Supplier, Amount, Date, If all matches in sheet 1 of workbook B with Workbook A...
  4. Z

    Macro to adjust line break in a text box

    Hi, I have below macro, what it does: It count the characters of concerned text and then add a line break whenever the text exceeds the text box size, then add this sentence "[more detail available in System]" in the last line of the text box. What I'm facing right now is: the text in text box...
  5. M

    Concaténer des cellules avec une condition

    Good morning all, I wanted to concatenate colors (in range B) with respect to each value which is in row A. (see image) . The result is in Range C. I used concatenation with condition like this: = IF (A2 <> 0; CONCATENATE (B2; ","; B3; ","; B4; ","; B5; ","; B6); "" ) because sometimes there...
  6. S

    Referencing a big number of ToggleButtons

    I have a table which has a ToggleButton next to each line. I would like to write a script that does something for each line of the table, but only if the ToggleButton on that line is pressed. Is there a way to define the if condition in an elegant way? I would imagine something like: For i =...
  7. S

    Sum only up to a certain point, then reset

    I have a list of staff with the hours they have worked on a weekly basis. I want to be able to put in a week's column when a payment has been made (this can be done sporadically and so isn't every week). When I put this in a column I then need a row below to reset for the following week to only...
  8. C

    IF statement issues

    I need to adjust the below to say if what is in orange is >=12 then return a value of "monthly"...right now it works how it is and brings back a value of 12, instead of 12 i'd like it to say monthly. I have tried adding another if statement but i keep getting 0 or errors. It's probably something...
  9. S

    Text Limt in a cell

    Hey, I have a query regarding the text limit on a cell. I have a cell that contains more than 100 characters. I have given the reference of that cell to other sheets now what I want is that on the sheet the cell will only have 100 characters the rest will move to the next cell. Exp. A cell has...
  10. G

    VBA - Delete all rows except rows which contain certain text

    Hi All, I have a excel workbook with 2 worksheets. Worksheet A has a very badly formatted data dump from our timesheet tool. Worksheet B has a list of project names. I am looking for a vba code which when run will delete all rows in Worksheet A expect for rows which have dates in them and rows...
  11. G

    VBA Copy data to another work book based on CONDITIONS

    Hi Team, I would like to copy data from one work book to another. The data has to be copied from BookA to BookB. However, the issue is that I am not allowed to edit the vba in BookB. Book A has a list of names and their forecasts. Book B also has a list of names and forecast but it also has a...
  12. T

    Random numbers between two values with condition

    Hi all I'm stuck with a mental block here: I want to generate 20 individual random numbers between two values (-3.28 and 14.50) but with a condition that the average of the 20 numbers should equal a set value, in this case 5.61 Can someone help please?
  13. S

    Conditional hiding of many text boxes

    Hi all, I have very little coding expertise and have searched the web and the forum, but couldn't quite find the solution. I am trying to show/hide hundreds of text boxes based on their values. Use case: I have an image of a map (jpg), which includes 222 locations. Each of these locations has...
  14. S

    SUMIF with condition

    <tbody> ID Amount Mac 10,000 Mac1 20,000 Mac2 30,000 Macy 5,000 Macy1 3,000 Macy2 2,000 Mike 15,500 Mike1 20,000 Mike2 10,000 </tbody> Hi, I would like to use formula to sum-up total for Mac, Macy and Mike. The formula I'm using is SUMIF(Column 1,"Mac"&"*",Column 2), but this...
  15. L

    Indicate First Duplicate Value in a Column when a condition exists in another column

    I need to indicate in the rows of column C where the the first duplicate value of Column A is when Column B is not blank. Any ideas? See below example <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Column A Column B Column C 12345 abc X 12345...
  16. M

    vba If condition help..

    Hi Team, Is there a way to shorten this code used in if condition. If Sheet1.Cells(i, 1).Value = "Green" Or Sheet1.Cells(i, 1).Value = "Red" Or Sheet1.Cells(i, 1).Value = "Blue" Then like If Sheet1.Cells(i, 1).Value = Array("Green", "Red", "Blue") Then Thanks in advance Regards, mg
  17. bobkap

    Delete column change counter

    This seems ridiculously easy, but I cannot figure it out after many tries. Scenario: I have approx 35 columns (and rows of course) of data. I want to sequence through each column and delete any columns that meet a certain condition. Here's one of my many attempts that do not work. Example of...
  18. L


    Hi Why this formula is giving me 0 =IF(E2>50, ,) I thought it should give me True if E2 > 50 and False if E2 < 50 because I did not specify what would be if the condition is True or False. Thank you very much.
  19. E

    for every cell & 2 Filter conditions Macro

    Hi all I'd appreciate some help in being able to delete all rows in my sheet where below condition doesn't meet or retain rows if blow condition meets. for every cell in column B that has the same name column F "Date and Time Completed" has the latest time and date, Format of time and date is...
  20. cyrilbrd

    Average header if range fits condition

    <tbody> 1 2 3 4 5 6 7 8 x x x x x x x x </tbody> Given the above, the results should be 4.625

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...