1. D

    Made Sound Alert More Than Once

    I found this =IF(U70>=W70,SoundMe(),"") and it works fine for what I have been doing. Problem is now I need for the sound to alert twice or three times and then stop (after the condition is met). Can anyone help me? Thanks. For a different situation: I need an alarm with a different sound...
  2. A

    Layered Toggle Buttons

    Can two separate toggle buttons cover a similar range? Let me explain... Essentially I want them to work together very similar to a file tree Category 1 Child category 1 Data Data Data Child category 2 Data Data Category 2 First I placed all...
  3. Emanuele

    Multiple Column and string extract

    Hi guys, I would like to know if there is a way to add more than 1 adjacent column for the presented code that I found on Internet and that Fluff helped me to modify in this Post Furthermore it's possible to apply a string extract (for example, extract the first 4 and the last 4 characters and...
  4. B

    X axis multiple data series

    I have stock options with 3 different sets of strike prices. ($7,250 to $9,500) ($8,000 to $9,000) and ($4,000 to $6,000). Each set has different profit multiples that are shown on Y axis. I want to put all 3 sets on the X axis and compare 3 profit multiple lines. Problem I get is that every...
  5. H

    Multiple Matches

    Hi, After previously having a huge amount of help via this forum previously I’m hoping one of you excel gods wouldn’t mind looking at another thing that’s got me stumped. So I’m trying to identify where a telephone call has been made by an agent during a time period they weren’t supposed to be...
  6. S

    Multiple Cell Check without VBA

    Hi, I have an hard time being able to figure out a solution to my issue and would like to see if anyone can help or has ideas of how this challenge can be resolved. I am trying to find a formula that is able to tell me if a cell has changed from a number to a text (horizontally) resulting in...
  7. E

    Title a Sub Routine with a variable.

    I have over a dozen checkboxes. They are titled checkbox1, checkbox2, checkbox3... etc. They each have a sub routine that tells them what to do when click. These subroutines are identical except for the number that indexes each checkbox. While this was easy to create using copy/paste. It is...
  8. M

    Index & match with multiple criteria

    Help! I am trying to get the Volume for a specific stock on a specific date, using Index & Match. The Volume figure I get is completely wrong. I don't know how to fix this. Date Symbol Daily Volume Symbol Price 11/18/19 A 100,168 A 79.12 What is the Daily Volume for...
  9. V

    Multiple csv file importer

    Hello, I am trying to come up with a macro that imports multiple csv files to different sheets and using the name of the file as the sheet name. I also need to be able to select the delimiter and also Consecutive delimiters. I have found 2 variants, one that imports multiple files but does not...
  10. D

    Copy and Paste Multiple Times

    I just want to know why I am the Visual Basic Applications (VBA) script isn't working as it should be. I am trying to copy and paste multiple tables, depending on the value I put into cell E1. I've used this code here: Sub CopyMulti() Range("A3:D19").Copy Range("E15").Resize(14 *...
  11. M

    Lookup across multiple columns

    Hello I'm new to the forum and look forward to your insights I have the weight band in column D and want to look up the prices in columns E to J how do I return the right price for each row? See below <tbody> Weight (lbs) Weight Band A B C D E F 167 A 156.53 126.79 107.98 90.78 78.94...
  12. M

    VBA create string array

    Hi Guys I have 3 columns A2:C10 where i put an Id in ie 12345 now some cells could have blanks, an Id or multiple Ids separated by a comma what i want to be able to do is if the cell has an id or multiple ids then create a string like this <found> for some reason its lost my string concat it...
  13. B

    Index/match multiple criteria, multiple results

    I need to review a list of data and return all of the matches based on 2 criteria and cannot figure out the entire formula. Below is what I have now but it only matches 1 criteria: "CASH IN IMPORT'!$R$5. How on earth do I add a second criteria, which would be column B of sheet '3.INT' matching...
  14. H

    Multiple Range Copy

    Hi - I have this code to copy rows to another sheet. I thought I could extend the range by add this code. But no, any suggestions on how I include the extra columns in the copy range? Tried this ws1.Range((ws1.Cells(thisRowA, "B"), ws1.Cells(thisRowA, "H")), (ws1.Cells(thisRowA, "K")...
  15. S

    How to Link your Access DB to Sharepoint?

    I have never attempted this before. But, is there a way to place your Access DB on SharePoint, but have it linked to where it saved in the folder its linked to? Also, multiple users should be able to open it correct?
  16. A

    Sum Multiple Columns Index Match Matrix

    How can I write a formula that will sum the value from multiple columns using an index match matrix based approach? The formula below will work when there is only one column that has the "OC_TECH" value, but I want to sum both values if "OC_TECH" occurs as a column header more than once. for...
  17. W

    Passive / indirect formula calculation and data copy - without VBA?

    Hi Guys, i just completed my registration as I guess you are playing the Championsleague of Excel, so I think it is the best place for a special question. Think about a workbook having 2 sheets, the first sheet has multiple lines meaning multiple records with the same structure. The columns...
  18. B

    Concatenate Multiple Rows until Non-Blank in Adjacent Column

    Hello I would like a macro that works through a long worksheet, set up as follows: Column A: product code (3-digit code) Column B: notes about product (free text - can span multiple rows due to character limits) Column A is blank in the rows where the data in column B has spilled onto...
  19. H

    Index / Match with random multiple rows

    I have a worksheet called Data. Each row relates to a customer repair. In column C is a part number (3 digit). There are many different part numbers distributed on different rows. If the customer rings to chase the repair the user puts an X in column S against that customer, so there can be...
  20. H

    selecting and naming multiple workbooks from listbox

    Hi - i'm using the code below to show open workbooks which the user can then select one. How do I update the code to allow the user to select multiple workbooks and how do I name them? Code in a Module Dim WB As Workbook For Each WB In Workbooks UserForm5.ListBox1.AddItem WB.Name...

Some videos you may like

This Week's Hot Topics