original

I am looking at a response from VBA Geek here https://www.mrexcel.com/forum/excel-questions/795401-macro-extract-10-highest-values-1-column-onto-new-sheet.html I am looking for something identical - BUT adding in a criteria lookup on a column i.e. Top10 values IF column C = "X" Original...

I have this =IFERROR(SUM(--LEFT(AP32,(FIND("h",AP32,1)-1))*60)+VALUE(MID(AP32,SEARCH("h",AP32)+1,SEARCH("m",AP32)-SEARCH("h",AP32)-1)),"") which turns 9h0m into countable minutes bright sparks at work have then adopted 8hr37m as a new way of writing without mucking up the original...

I have a report that has many columns, A - CC. There are ten columns I need and want to delete the rest. Is there a way to specify the original range and delete them all Except those in a list? -Cue

Hi all, kindly advice me for a VBA code so that to run through col. “A” and where find the row which contains text “Deductions” the number in adjacent cell in col. “J” should be minus (-). I present below the original data and the expected result. Thanking you in advance <!--[if gte mso...

Hi all, kindly advice me for a VBA code so that to run through col. “A” and where find the below duplicate descriptions should replace the first 2 as unique placing specific words on right side “operation” & “administration” and the 3th should be deleted. Below I present the original data and...

Hello all you MrExcel experts This concerns my posting #5 & #6 in a thread started by Hitbid called ‘Question about optimizing simple code’ dated Nov. 3, 2018. The link to this is: https://www.mrexcel.com/forum/excel-questions/1076409-question-about-optimizing-simple-code.html I had offered...

<tbody> original date collection date 1 10/1/2016 10/8/2016 2 01/05/2017 01/07/2017 3 10/10/2018 10/17/2018 4 10/20/2018 10/30/2018 </tbody> I have a list of 300 sample, i need to know the ones that were collected 7 days and more from the original sample for example the...

Hello, I have a macro that works just fine when running on the original system generated Excel report from which I get the data. I then created a macro enabled template which requires copying all the data from the original worksheet and pasting onto the template. When I run the macro from the...

Can you create a macro that will copy the active tab/worksheet in a workbook and save it as a new workbook, and close that new workbook. The new workbook should be named whatever the tab/worksheet was named in the original workbook, and the new worksheet should have that same name on its tab...

Good day Demigods, Hoping you can help with this. 'Workbook' is a macro-enabled template. What i want to happen is have a button on 'SheetA!' within 'Workbook', that when clicked on, it opens a new instance of 'Workbook' and copies the contents of a specific range of cells from the original...

Hi, I currently have a macro to enable conditional formatting to highlight a row dependent on 1 cell. I can do this fine. The problem is that when I add another macro to remove this conditional formatting, to go back to the original workbook, I can no longer run the original macro to put the...

I am trying to copy a worksheet to a new workbook and change the formatting. But the macro only changes the formatting on the original workbook. How do I gain focus on the new workbook? Sub Copy_WorkSheet() 'open and copy sheet to new wb Sheets("Sheet 1").Select...

i want to creat a list from existing list ignoring zero values For Example <tbody> Original List List to be created Aslam Aslam Akram Akram 0 Mohsin Mohsin Waseem 0 0 0 Waseem </tbody>

What I am trying to do is when a workbook is opened check against a list of authorized users before opening. And I go this working already. The next step - if possible - would be if they are not on that list open a copy of the workbook in a state WHERE THEY CAN NOT SAVE OR SAVE AS and close...

Im struggeling with a macro which needs to convert 15 min intervals to 30 min Original data looks like <tbody> 00:00 2 3 5 00:15 2 1 4 00:30 5 2 6 00:45 5 3 4 01:00 7 4 2 01:15 7 2 3 </tbody> and I would need such an outcome somewhere right or left from the original <tbody>...

Is there a formula that can give me the string of text after an intsance of DBA. Assuming the original text is in Column A <tbody> Original Text Desired Result Elite Southern Construction LLC dba Master Roofing Master Roofing Riland Richardson, Inc. Dba C & R Trucking C & R Trucking...

Hi, I was just wondering, is there a way of once the formula has worked to just keep that original value there? For example, i'm using a VLOOKUP to get my results which work perfectly. Once i get that result i dont want it to ever change as what would happen is when i update my spreadsheet...

Hi all, kindly require to provide me support for a VBA code, so that to adjust the numbers in col. “B” on left side like the below format. 0000-00202121 Therefore that, where the number contains 7 digits, should complete just 0 and then the – and 0000. e.g. 0000-01202121...

Hello, On paper, I think this should work. I want to make a formula that if special criteria are met, then a separate formula is calculated based on its own special criteria. If the first criteria is not met then nothing happens. This is what I started with...

I have a data set with 4 columns - Original Bank , Acquiring Bank, Acquired Status ( Yes/ No) , Final Bank Name Depending on whether the acquired status is yes or no, I want to copy the bank name to column Final Bank Name. Following rules apply :- a) If the bank under column Original bank has...