if then

Hi! I was hoping someone could help me figure out how to get a form checkbox (open to using ActiveX as well if easier) to automatically tick once the color of another cell changes. So if the color of A1 becomes green (and I can indicate what green exactly or if possible within a range would also...

I have some code which looks for some Word files in a particular folder, opens each one in turn and populates a spreadsheet with some document properties (including the "Subject" field - which is the reason I need to open them all). This works fine and I've tweaked my code so that the list of...

Hello Folks, I'm trying to use the MROUND function with an IF statement. I need values in Column "A" to be rounded off to the next multiple of 3 if the value is less than or equal to 42. If the value exceceds 42 it needs to be rounded of to the next multiple of 6. The issue I have is that if...

Hello, I am having difficulty adding an IF statement withou it causing problems. I need the statement because when the following code searches and finds nothing, it stops. I tried an on error goto, but that made this code not work at all:confused: Sub Lookup(Target As Range)...

Hi. I've come up with VBA code that works fine, but is long, and probably can be compressed into something shorter or more tidy. Is there a way to substitute these multiple statements with something like arrays or anything else? I'm quite new to VBA (only programming I'm doing) - tried few...

Hi everyone, I am trying to set up a formula for the following type of scenario: Column A ---> Column B: Apple ---> Fruit Kale ---> Vegetable Banana ---> Fruit Carrot ---> Vegetable Kale ---> Vegetable What formula can I put in Column B...

Hi, I'm an excel formula newbie and was having trouble trying to figure out the correct formula to do the following: In Column A I have a list of various values ranging from 0-4000. I'd like to reorganize them (or recopy them) into 3 columns delineating the values into certain ranges based...

What is the best formula to use if I want to (in sheet 1) search for the cell that contains the text "WHEAT-SRW" but not an exact match, and return the value in column H that is in the same row as "WHEAT-SRW"

Hey guys, so here is my code: Public Sub newcopy() Dim WSCount As Long, StartCellRow As Long, i As Long Dim sht As Worksheet Dim region As String WSCount = Worksheets.Count - 2 Application.ScreenUpdating = False For i = 3 To WSCount + 2 region = Sheets(i).Range("E1").Text...

I'm thinking I need to do an If/If Then with Vlookup function. I essentially want identify if something is a "unit" or a "case" and return a specified number based on its code. There may be something easier. Excel 2010ABCDEF1PackIDunitcase2unit1234123453case12241224545Desired OutputIF A2 =...

Hello there, I am working on a personal project. Goal: I want to click the button that is linked to this Macro, and have the Macro check to see if a certain cell (F2) on a certain sheet (Generator) is equal to Error. If that cell's value is Error or "ERROR", then I want the Critical Error to...

Hi, Im stuck in an if question. I have 3 colums. In the first one I have a number, in the second column a have "yes" and in the third column I want it to SUM the number in the first column and a number in the second column associated with the word "yes". Is it possible? For example the...

I am trying to fill some autoshapes with color if any text is entered into specific cells. This works just fine if numbers are entered, but doesn't work if letters are used, I have looked at some possible solutions but they all seem very complex, is there any way to easily transform below into...

Hello all, I'm having an issue with an embedded IF/THEN Formula which has three different IFs. Every values in the L column will change. The different choices are: No quotes, I'm putting them there to show the spaces before or after the value. 1. "# %not " (# being a single number) 2. ST00...

Hi there, I am trying to create a function which does the following: In Spreadsheet "2016" column "Destroy" I would like to put: if [product code (which is found in spreadsheet "data 2") is AB (which is found in spreadsheet "data 2" on the same row but a few columns over) then the Destroy...

I am working on a spreadsheet which has different values in column B (values are 3, 4, A, B, C). I am trying to create a conditional format that will highlight column E. Each item in column B has a value that needs to be met. Example A requires at least 160, C requires at least 32 I would like...

Hello, I need a little help as I'm out of my depth right now. My existing code is horrible. It does a Double loop and its copying the Cell every time it doesn't find a match. Ideally, I want it to take the contents of sh3.Range("A" & iRow) and search sh1.Range("A:A"). If it finds a match...

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