multiple

Please the number of first rows to be deleted INCREASES along with the worksheet numbers. For example, row 1 (first row) would be deleted in sheet 1, row 1 and row 2 would be deleted in subsequent sheet 2, row 1 row 2 row 3 would be deleted in subsequent sheet 3, and so on. Please any help on a...

Hey there, I have two sheets on hand, and need to sum the multiple results in condition at the third sheet. Are there anyone can tell me the formula that can achieve it? Thanks! Here's what I have: Sheet 1 Sheet 2 And here's what I want: Sheet 3

I've been working on this for a while now without any luck, so I thought it might be time I asked the experts. I have 2 workbooks: Workbook 1: Raw postcode data only in column A Workbook 2 (Index): Postcodes (column A) with all localities affiliated with those postcodes (Column B). Note that...

Hi all, I tried to google a day to solve this issue but it did not work. Can anyone help me to give me a solution, please? How can I rename multiple worksheets (from sheet2) from a column value (Date) as the photo attached by using VBA code? Thank you.

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