multiple

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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