if then

I have a tab in Excel named Admin Input. In Cell B5 I have a date 12/31/2015 <tbody> Begin Date of Fiscal Year 7/1/2015 End Date of Base Period 12/31/2015 2 Years Ago FY 2014 Last FY 2015 Current FY 2016 Budget FY 2017 </tbody> I have another tab on the same file named as Input...

I've only just started learning programming in VBA for Excel.2013. I have a sheet with 9 columns and 60 rows. Note that Rows 1-25 consist of 9 columns but B through D are merged. I'm trying to add a command button that will hide the unwanted rows for me. The unwanted rows will be chosen through...

Hi, I have a report in Excel with 29 columns that I have filters on. I need to be able to see some of those hidden rows that have been "filtered out", without modifying my original filters, and wanted to know if there is an IF THEN code I can use in VBA to show those rows. In column N of my...

hi - I have two spreadsheets... and trying to use a VLOOKUP formula (Or something similar if there is better) to basically do the following: - Spreadsheet A has a product name - say "Color Hair Care" - Spreadsheet B has a more detailed product name and a UPC code (separate columns) - "Color...

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...