1. C

    If & Concatenate Multiple Fields

    I am trying to concatenate multiple fields if there is data there. G2 is what I want the data to look like, only picking up the cells with data and concatenate with the heading with + between each fields.. I managed to only get one cell and header =IF(A2="No","",CONCATENATE(TEXT(B2,$###K"),"...
  2. R

    Fill cells based on data in another workbook

    Hi all hopefully someone may be able to help i have a 6 workbooks.1-5 contain the data from the different offices about the times they are working. I import the data into workbook 6 onto different worksheets. i displaythem in a Gnatt style chart which i have created using the following Formula...
  3. J

    Macro to keep track of username and time for users who opens an excel file

    Dear Team, I have got a macro in an excel file which tracks the username and time of the users opening the file which I definitely need. The problem is that if 1 user opens the file and leaves it open then it doesn't track the name/time of other users who open the file when its in use. Is it...
  4. P

    Query Screen with Multiple Options

    I would like to use our case details listed on a spreadsheet to allow staff to enter one or more criteria and have the details of all relevant cases show up on another tab. I have attached a sample of the type of information recorded. If possible, but not a requirement I would like to query...
  5. L

    IF + MATCH + repeated values

    Hi, maybe some of you guys can help me out, i have the following table: Hour Event Disconnected at Time out 01:25:36 Ping down 02:25:17 Ping down 03:47:50 Ping down 04:50:50 Reconnected 05:20:14 Ping down 06:14:15 Ping down 07:08:55 Ping down 08:00:01...
  6. J

    Need to import 4 sheets from 50+ workbooks into a summary sheet

    Apologies if I'm not explaining this well; I'm a novice at VBA. I need 4 sheets to be extracted from 50 workbooks and copied into a summary. The VBA needs to work in the background. Can anyone help. I wore this code but it's clunk and doesn't repeat. Sub CopySheetFromClosedWB()...
  7. A

    Importing Multiple csv files

    Hello I have an excel sheet in which I regularly need to import data that is in *.csv format. I would be very grateful if someone can provide me a VB code where I can import in a query all these csv files into the existing Excel file. I have been able to find code where the codes *.csv files are...
  8. A

    Problem in exporting into excel when Separator in txt files is "|"(vertical bar) instead of ","

    Hello Can anybody tell me a VB script wherein I have to export multiple txt files where the separator is instead of "," is "|"(vertical bar). I have seen multiple codes where the separator is assumed to be a "," but no VB script for "|" which is a separator. I have uploaded a sample txt file...
  9. M

    msgbox appearing twice

    Hi, I was hoping someone could tell me why my msgbox gets triggered twice? Its in the comboboxchange so my initial guess was because i was making Comboxarea2B.value="" that it was triggering it again but if this is the case then how do I make Comboxarea2B value blank without triggering the code...
  10. thelukeee

    Importing Multiple .Txt Files Into Excel Based on the Date Last Modified (VBA)

    Hello everyone, I'd appreciate some coding help in Excel using VBA. Background: There is a new .txt file made for each furnace run. The .txt file is created automatically in the system, and goes unedited by anyone, therefore using the date last modified is a viable way to sort through the...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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 *...

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