if then

Would love some advice on this! I'm honestly not sure if it's possible. It feels like it *should* be. In one sheet, I have a list of products, each with varying release months. Adjacent to the launch month, I have plotted the succeeding two months to create a 3 month total "New Release Period"...

Hi! I have set B of numbers in range of B1 to B142. I have set C of numbers in range C2 to C142. I have a set F of numbers in range F3 to F142. I have a set M of numbers from H2 to BS2. I need something to check that if (cell in M = cell in B) AND if (cell in F = cell in C) then enter "Yes" in...

Looking for help on a relatively simple (i thought) formula for doing two things in one cell. I have a 2 sheet workbook. On Sheet 1 i have two cells (A1 and A2) with NAMES OF EMPLOYEES in them. I want to transfer that info from Sheet 1 to Sheet 2 to let's say Cell A50 on Sheet 2 but with the...

Hello! I am trying to develop a Function that will Sum the values in column F, but only if the cell's row has "Clinical" in column D. My spreadsheet looks like this: While I was able to use the IF Function to perform this [...

Hi, I am new to this Forum and very new to using VBA in excel, so please excuse my lack of proper vocabulary or knowledge. I am a film editor and we have EDLs that show us all of the cuts in a film with time codes in and out - an excel workbook of the movie. We have a separate document...

Hi I kinda know how to do this with single cells but not with named ranges...everything I have googled so far seems to point to dependant or cascading lists but is not what I need....anyways Basically Say I have a drop down list in column A (in each cell) A drop down list in Column B (in each...

I need help getting a formula to work properly in a cell on a different sheet. Here's what I need to do. I need the cell to Look in range 'Frac Report'!E8:CQ8 for the entry "LS" or "LSC" and return the value in the matching cell in row 6. Also if there is no data entered in range 'Frac...

Hi there! I am wondering if anyone can help me figure out an if then statement I am working on. I am trying to direct Excel as follows: if k2 contains the number 65, then multiply T2 by.65 (or) if k2 contains the number 70, then multiply T2 by .50, otherwise (if k2 doesn't = 65 or 70) return...

I am working with two separate data sheets. One lists all the products in one column with pricing usage and vendors in columns next to it. In the new data sheet that I'm creating, I listed all the vendors in separate columns with the part numbers all in column A. I need to show (by highlighting...

I'm trying to have my macro check if cells in a row on two different sheets match. I'm able to get it to work using And & Offset, but I'd like to know if there's another method to accomplish the same thing in a shorter code. This is essentially what I've got so far: Dim Sheet1 as Worksheet...

Hi everyone:) I have a set of data that looks like: <tbody> From To Cost 0 1 10 0 3 11 0 4 15 1 2 6 1 5 1 2 1 3 2 4 1 3 ... ... ... ... ... 4 ... ... 4 .. ... </tbody> And it goes on. Question: is there a way that excel can do ---> IF B2 =1 THEN copy A5, B5, C5 and...

I've spent probably 10 hrs trying to get this to work. I've been trying if then formulas but I cant get it to work. I want to be able to put peoples names on the cards on the first page. The venue cuts those cards up to give to the waiters. I need to check whether the guest wants chicken fish...

Looking to create a conditional formatting code that would allow the following to occur: IF the data in column B1 contains "//UDMN" THEN populate column A1 with state code "MN" I have a list of several (really it's a table) that has this listed out where it shows others such as "//CEFL" = FL...

Hi, I've been banging my head against the wall trying to determine what i havewrong with my code. I have an employee roster (Sheet1) and I'm trying to get the code to look through Sheet1 and if the Last Name field is NOT "Vacant" or "Recruit" , and the Emp ID Field is not blank, then list it on...

Hey Mr.Excel I'm working on a macro that controlls worksheet. I want my macro to check for each cell if the cell.value is empty in the range from ("F4:F20") and if that is true then check the if the range from U4:AD4 dont have the value = "LB0.1" Sub populateB()Dim rng1 As Range Dim rng2 As...

Hi all, first of all, I am looking forward to a productive cooperation with all of you guys :) It's my first post, so let's get it up and running! My problem is the following: I would need a continuously, conditional numbering with a reset function. Let me give you guys an example for a...

I am trying to help someone else and this one is beyond me. The setup is that the user can select a category in one cell (drop down) and based on their selection I would like to be able to have the result in different drop down options. Let's say that in cell B1 you select a state (from a drop...

Hi - I have a column which has names of businesses but some of them have the zip code attached to them. For example most cells are just ABC Company 123 Company Def Company But some are ABC Company90210 123 Company10011 Def Company20007 In all the cells that have zip codes, they are always 5...

Hi and thanks in advance for any help. I am using the following code to automate a mail merge through excel at the click of a button. Option Explicit 'change this to where your files are stored Const FilePath As String = "C:\Users\chowell\Desktop\" Dim wd As New Word.Application Dim...

I am looping through a named range (Log) to see if the cell value matches a variable that I enter an inputbox and then if an offset cell matches another variable that I enter in a second inputbox. My problem is that even if the matches are found the Msgbox still pops up and I exit the sub. I...