Search results

Hi all, I have VBA that will send an e-mail and attachment to all e-mail addresses in a range, it worked well. However, I must have inadvertently changed something and it now only sends the e-mail to the first email address in the range and does not loop through the range adding all the e-mail...

Hi all, Hope someone can help been scratching my head all night. I have a code which calls an unprotect sub and once the code has completed calls the protect sub. I am getting an error on the protect code. I cannot see anything wrong with the sub. If I remove the 'Call ProtectAll' the code...

Thanks for replying, I will need to do this later as currently working, cannot upload from the work computer. basically, I need to find the time difference between the first name in the list 'Paul' and the second instance of 'Paul with date and time in column A, names in column B. and so on down...

Hi all, I am looking to see the time difference in hh:mm:ss in a list ordered by time oldest to newest where the criteria matches Col A = dd/mm/yyy hh:mm:ss Col B names (criteria) I would like to know the time difference from one instance to the next where names are the same. Any help much...

Thank you. Got it, IO used indirect and vlookup to my named ranges. Worked great.

Hi all, Is it possible to enter a named range into a formula depening on value in a cell. I.e If cell value is January use January named range, if cell value is February use February named range. I have looked at various posts and I am beginning to believe it cannot be done and I need to look...

Thanks, for answering Haz. I had solved it by doing exactly that. Sometimes it just takes asking the question to get your brain working. Thanks though.

Hi all, Can I use formula to identify whether a customer reference has been included in more than one fault report during the same time period or overlapping time period. This means I need to identify whether the customer ref appears multiple times in the data and then identify if the...

Hi all, I need to find the minimum number in column if it is the same reference number and for the life of me cannnot work it out. I can find the minimum of the whole column but do not know how to get the formula to look at the reference no also. Thought a countifs would work but no joy...

Hi Narayan, Wonder if you can help again. The date format seems to have changed I haven't changed the code! I enter the date DD/MM/YYYY, when it copies to the Data tab the date changes to MM/DD/YYYY. It is driving me round the bend, I haven't changed the formatting on the sheet or anything.

Hi Narayank991, You have come to my rescue again. This is great. If I want to add this code to another procedure should I rewrite the original sub with this code included or just Call the procedure, which works well, just not sure if it is best practice. Thank you very much.

Hi Indranee, Here is a code I use you just need to create the button assign the code. Just change the sheet names etc. Sub Mail_ActiveSheet() 'Working in Excel 2000-2016 'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm Dim FileExtStr As String Dim FileFormatNum As...

Hi, I have data that the user imports to the data sheet, I have a text box where they enter the appropriate date. I would like this date to populate column A next to the imported data. With each import the date should be different. Not overwrite the previous dates in column A. I just cannot...

Hi Hui, Thanks a lot this is great.

Hi, Looking for help, I have code to copy a data range from the Input sheet to the last row used on the data sheet. The problem I have is my code picks up the blank (formula)cells and pastes them to meaning I have gaps in the data. My question is how can I copy the range without the blank...

Thanks Somendra, The array formula is great. A pivot table was not an option I had wanted on the main spreadsheet.

Hi all, I have an array formula where I am looking to return only 1 reference number if the number of incidents are equal to 4. In the spreadsheet the reference can appear multiple times, I have added a column to identify the first incidence of the reference number, not sure if I need this...

I have now updated my code but if any of the experts have advice for me I'd love to hear it. This code still takes sometime to run but I o where near as long as the above code. Public Sub CopyRows_clearData() Application.ScreenUpdating = False Sheets("All").Select ' Find the last row of data...

Hi all, I've tried a couple of different macros and I'm looking for best practice. I'm not too experienced with VBA but can normally follow code and adapt to my needs. I am looking to copy all rows that contain 'Yes' in column 'P' sheet 'All' to sheet 'Incident'. So far everything I've used is...

Thanks for your help Hui, I think I have found a solution to what I require. I did not know what I had to do to get my needed result. I have a list of incidents and I needed to find a way of recognising when a certain number of incidents has occurred within a 24hr period. I have a column of...

Thanks, unfortunately that does not work.

Hi Everyone, Much help required I am looking for the best formula options to count incidents within a 24 hour period. I have a list of job times, in a very busy period if incidents reach a certain level it triggers an action. I need a way of working out when the trigger was reached. I have...

Neither is working, I cant download the example as currently at work. I get a #REF error

Brilliant thanks muchly.

Hi everyone, I have a sheet that contains data on every 29th row. I am looking for a formula that I can enter on a new sheet and copy down, line after line. I have tried =OFFSET(Summary!A5,(ROW()-1)*29,0) .The data I need is on Row 4 and then again on row 33, row 62 and so on. Mt new sheet...