blah

Columns A and B contain dates. But sometimes, users alsoinput words along with the dates. For example, Cell A2 could say, “9/13/18” and Cell B2could say, “Tentative 9/16/18”…or really “blah blah blah 9/16/18 blah blah blah.” I need a formula in Cell C2 to subtract the dates.Obviously...

Hello, I want to be able to manually change the "Count" and depending on that number, a formula in "Total" will display the sum results from the top down within Column L. My range is L4;L18. J K L 4 blah blah 175.00 5 blah blah 175.00 6 blah blah 50.00 Count: 2 Total...

Oh boy. So I'm new to VBA entirely and I made a rudimentary inventory program in PC using VBA. I tried it out on Mac and it didn't work at all. I am not even sure where to begin the process of coding it to work for Mac. It's a gift for my Mom so I hope one of y'all is smart enough to point me in...

I understand Conditional Formatting on reports in MS Access.......but in Excel it throws me. Plus, I don't use Excel nearly as much as Access. I can do basic formulas, no problem. Getting fancy starts causing problems. I have a cell (T50) that is calculating the difference between cells R16...

Hello, I have been working on this formula for the past few days and it is just not working at all, please help? In sheet 1 - in column A, I input dates from Sheet2 and Sheet3 and insert the desire formula in C2-C9 it should pull in the invoice# and the quantities in D2-C9 from sheet2 and...

Hey guys, so i have a roster that has names in the first 3 rows. How do i sort the 3 in which the emtpy row will be automatically placed at the bottom of the 3. EX: <tbody> Names: Notes: X Blah blah blah Y asdgh C fgsde </tbody> If i delete all the data in Row 2 (Name: "X") how would i...

Hopefully this makes sense... The first sheet we will call "Pick" and is formatted like this: <tbody> SKU Description Call Name BC QTY B/O Aisle Row Tier Truck Stop 1234567 Blah Blah Blah _____ 1 301 A 1 1 1 </tbody> There is an empty row under every entry. The...

so I am trying my first private worksheet macro and having a problem with my second statement . if the 1st test passes everything works great. if the second test fails the message box just keeps repeating Private Sub Worksheet_Change(ByVal Target As Range) If Range("b5") = "Loyalty2gether"...

I have an excel sheet with the following layout: My goal is to find each occurrence of a machine number that has a downtime equal to or greater than 4 hours and put that info Plus the reason into a separate table. I want to search by machine number find downtime =>4 and return each occurrence of...

Hello, I need some help creating VBA code where the cell color changes to yellow if an individual’s total for that particular month is over 100%. Here is a sample of my data: <colgroup><col><col span="2"><col><col span="12"></colgroup><tbody> Name Title Plan Notes Mar Apr May Jun Jul Aug Sep...

Hi everyone, I have an email subject that looks like this: RE: Blah blah - Blah blah, 1234-56, Blah blah blah I was wondering how to extract "1234-56" from the email subject. I tried: If myemail.Subject Like "****-**" Then But that only gives me true/false and I want the actual data...

Hello all ! I am having difficulty with the following: I have a sheet with lots of data; there is a specific array of data from which i need to retrieve the entire row (or selected columns), matching a simple criteria, i.e., the contents of one of the arrays´ cell. Illustrating: <tbody> APP1...

hi I have a workbook and it has a lot of tabs and there is it also comes up with a error message "This workbook contains one or more links that cannot be updated" error message I have clicked on "Edit Links" and it is says it is a workbook with blah blah location, and when I go to break the...

Hey guys, Is there a way to shorten the following code so that I do not have to write or Range ("A1") = every time I wanna add an or statement? Thanks for the help in advance. ElseIf Range("A1") = "Location 1" Or Range("A1") = "Location 2" Or Range("A1") = "Location 4" Or Range("A1") =...

Hi there, How do I extract just 3 characters before a specific word "loadsheet" within a cell <tbody> description output <tbody> blah blah auh cpt loadsheet blah blah </tbody> cpt </tbody> Regards, Bernard

Hi there, How do I extract just 3 characters after a specific word in a cell. Below A2 has a bunch of information jammed into 1 cell. I need to grab just the 3 characters after the word "loadsheet". The blah blah blah is a bunch of random junk that i don't need. <tbody> description output...

Hi! I have a group of cells on sheetA which contain SUMFIS formulas connected to sheetB. Amounts are posted on sheetB and then the sums are calculated on sheetA. I have conditional formats set on the sums on sheetA to go red once the sums exceed a maximum amount. However, I also want to add a...

Hello Everyone, Using Windows 10 on a newer surface. Have a .xlsm file that's about 14,000 KB. Literally crashes when i try to do anything.. convert whole row of data to number, calculate formulas, etc. When i google this seems to be a huge ongoing issue and seems to have the same message...

I have inheriteda list of contacts that is in an appalling state. There is almost noconsistency in the layout. In some cases all the info is in one field. Others amix of info, in rare cases properly separated. <o:p></o:p> In somecases two different contacts aqre separated by one empty row, in...

I am running a macro against 20 workbooks. It appears that there is no consistency in how thay are created. I am trying to copy a few cells from one of the sheets. I am using the .find method to locate the beginning of the data to copy. I thought I was going to be able to do...