if then

Sorry. I know there is a simple solution to this and I’m just blind to it. Calculating Sliding Scale Percentage Current Formula in cell A46 =IF($B$33<5000,”.007”,IF($B$33<10000,”.006”,IF($B$33>9999,”.005”,””)))*10 This works perfect, however I need this formula to consider the value of A43...

Hello I am trying to construct a vba macro to count everytime a cell contains a hyperlink in range of data. Currenly having it search the row for a hyperlink and then if it finds a hyperlink it will count and not delete the row, deleting the row if it doesn't contain a row. I am currently having...

I am having trouble writing a code to recognize if a number is odd or not and then determining what to do from there... It keeps pooping up with an "object required" error. Please let me know how I can fix it, or if you have ever come across this problem. Here is my code STNDRD=17 If STNDRDR...

Long time lurker, finally broke down and made an account (1st post). I am in need of an if then statement in VBA. What i need it to do is count how many times each cell in Range B is in range A and does that count equal 10. the following is the formula that works in excel but not in VBA...

Basically im trying to filter a large set of data. I have people's names and want to delete all rows not containing these names. I used this macro originally: Sub DeleteRows() Dim Cell As Range, cRange As Range, LastRow As Long, x As Long LastRow = ActiveSheet.Cells(Rows.Count...

I'd like to setup some sort of a macro in excel with a barcode scanner I have. We have a factory with a large number of machines which are all bar coded that also have travelers with the production order in a barcode format. Right now someone walks the line and manually writes which work order...

Please can anyone help me to make a formula for this sheet? Thanks in advance!

So what I am trying to do is when a button is clicked, depending on if a certain cell contains a text, will bring up a certain userform. So if "I6" has a date in it, userform1 would show. If "I6" and "I10" have a date in it, then useform2 would show. If "I6", "I10" and "I14" have a date in it...

Hello, I have a slight problem. I want a macro that can check if a value on sheet 1, column B matches one of multiple values in sheet 2, column B on and if so make the cell on the first sheet turn green. I need this to compare batch codes and to quickly see what ones have been approved. Only I...

Hello, I have a workbook with 2 sheets, sheet one has column I. Column I is filled with Percent's. Sheet has cell B2 filled in with one of the following "Jan, Feb, March, Apr, Jun, Jul, Aug, Sep, Oct, Nov, Dec." The Conditional formatting formula I thought would be something along with lines...

Your help would be so appreciated if you feel it, thank you. If Column "E" has an "S" or "U+U" in the cell, then REPLACE the instance of "Favorites" in that row's Column I with: <tbody> "FAVORITES 1 (Solos/OCs/twins only)" Similarly, If Column "E" has an "D" in the cell, then REPLACE the...

I receive a large file each month which tracks staff who badge through a particular badge reader. I am trying to write a formula to tell me if each row was captured during regular business hours or not. below you see a paste of my excerpt (I cannot attach a sample excel file to this for some...

Hi - Newbie here. Read the FAQs, rules and searched the forum and did not find an answer so created a new post. Bear with me. Question: If cell's contains this do this until... Hypothetical Example: Trying to write a formula to look for characters that begin with 6, then return the first...

Hello all, I'm hoping to get some help with the following issue. I've written a set of macros around a few worksheets that I analysed for a thesis project. The project is now finished but I'm doing some follow up work and thought it would be safe to update my Office 2016 for Mac now. After this...

Hi guys, i am trying to write a vba to add values of col c (Weight) if the value in column a starts with a "W" and numbers after the "X" is less than 30 then add them all up and put the sum in cell H2(under Light). I've been working on this for a few days and cant quite figure it out, the...

Hi, Please help.. Need a formula. I couldnt make the string?:confused::confused: i NEED FORMULA ON "H" that will output the following scenario? many thanks <tbody> A B C D (TOTAL b &c) E F G H 1 0 0 0 0 0 0 0 NO DEMAND 2 0 10 10 20 20 0 20 In Process 3 15 0 0 0 15 0 15 Need to Order...

Keep in mind I'm self taught so please excuse any ignorance of mine. Background: Daily, I receive a report that consists of 20-25 text files, 1 for each state we have business in. I have a process that consists of a few different scripts run one after the other. It does a lot to the files...

Hi, I have this code and it shows me "Object doesn't support this property or method" I dont know if anybody knows waht might be the mistake! Sub Horror() Call LastRowPivotTable With ThisWorkbook Set wb = ThisWorkbook Set DR = wb.Sheets("Draft") Set PT = wb.Sheets("Pivot Table I") MasterAcct...

I have this code but sometimes it may search for a data is not, so I want a IF THEN formula maybe if it doesnt found anything it can still work, or maybe IFERROR Sub PivotTableFilter() Dim MasterAcc As Variant MasterAcc = Workbooks(Wk_Name).Worksheets("Draft").Range("C4").Value With...

Hello! I have the next code and is working but i would like to make it a loop, for every single cell there is with information. Sub Internet() If Sheets("Draft").Range("G7").Value2 = "INT1" Then Sheets("U-Detail").Range("R11").Value2 = Range("'GL Accounts'!B1").Value2 &...