ifthen

I created 11 different tabs to be filled out. Is there a way to have the data in each of those sheets auto-populate into one master sheet? I need to show the totals of each product selected. I only included the Master Sheet and 2 tabs below. Thank you for your help. Master Sheet...

I am self taught and don't always know the right way to ask the questions to google. 2 days ago I posted my sumproduct formula and with help it worked perfectly. Now I am trying to add an IF for a zero return, (which is ok, I need the zeros to populate), but if it is not a zero, I need it to be...

I need to use an if statement to add an attachment to an email if cell G5 contains specific text (e.g. "Specific Text"). I've tried using If Range("G5").Value = "Specific Text" Then .Attachment.Add "C:\Documents\MadeUpFileLocation\ImageName.JPG" End If but the debug is highlighting the...

Hello, I want to insert "yes'/"no" in columns I & J below based on if each row has 3 No's or 3 Yes's but the cells are non sequential, how would I write this? using a countif or an ifthen? Required skills Met Yes Required skills Met No Total hours Count Total hours Met Yes Total hours Met...

I have a project that I am working on that is copying data from 1 tab and pasting into the other but I am coming upon an obstacle. I have a series of code that is comparing data in column A and if it matches then it pastes the quantity in column F. However if there is a row where the data...

Hello, I am working on a formula which populates each row with "Client Profile" (C8) if the corresponding year for each row meets the years outlined in the client profile sheet (D8 & E8). If it does not, the cell returns $0. I have accomplished this with: =IF(AND(D7>='Client...

I have a list of zip codes in a verticle column (A32:A200) on a sheet Named "Formulas". I have an image named "Bolt" in cell C4 on a sheet, named "New Job Log". Also on that New Job Log sheet, I have two non adjacent columns. On the left, starting at C5 is an empty column of cells. On the...

It's been awhile for me... what I need is to setup a formula to look for date in one cell then if the condition is met have it total the number in the next column. In the example table below the formula I'm trying to solve is the 'Total" column. TIA Name Month Number Month Total Test A...

Hi guys! I currently have a workbook that has a master tab (ACCTHX) and a tab created for every member. The ACCTHX tab has a line for each member and each month (so one member will have 12 lines- sometimes more). I need to copy and paste their 12 or more rows (columns D:H) into their...

Hi! I am trying to figure out a formula for the following (hopefully I explain it correctly) I currently have a sheet where the date of training is entered, and the expiry date is then auto-filled based on the first of the next month of the following year (some have 2 year anniversary dates)...

I have a query that every day pulls yesterday's data from an sql database and drops it into Access. SELECT Date, InvoiceNo, Customer FROM SalesDatabase WHERE Date=Yesterdaysdate What I need it to do though is when today's date is a Monday, I need it to gather the data for Friday, Saturday...

I have two sheets. Sheet 1 looks like this: Sheet 2's layout is exactly like sheet1's, but rows' sequence may change and some $ amounts may change as well Currently, I am using this VBA code to compare and contrast two sheets, then highlight the differences. Sub Try()...

I need aformula that will auto populate like this: If A1 shows “M”,then auto populate in A2 “T”, or “T” , “W”, or “Th”, “F”, and so on. I was tryingto write an “IF” statement, and then a VLOOKUP, but I am not good at writingthese formulas. Could anyone assist in helping write this. I...

Hello, I’m stuck in a situation where I need to be able to use VLookup to pull information based on text strings that all start with qvs. I’ve used normal concatenate across the 5 columns in question but it returns too much information and my vlookup formula errors. Is there a way to write a...

I'm a bit new to VBA. But, I've gotten pretty far into this project at work. However, I've come across a logic problem that I don't have a knowledge base wide enough to complete: The problem goes like this: I have many Work books that I need to export to a master WB one at a time (this wb then...

I'm very new to VBA and figuring it out through YouTube videos and online google searches. I'm having some problems finding out how to do an If Then statement in VBA. I have the same text that can be found in either cell A47 or B47. The text is "Other." I want to do an If statement that says...

Hello! I have a "Ship" button with a macro that copies filled out rows in an order form and adds them to a list of shipments in another workbook. In Workbook A, there is a table of part numbers and their quantities, referred to in the code as iRow. Sometimes I have to make partial shipments, so...

Hello everyone. I am a new user and a beginner in Excel's VBA. I was wondering how to create a macro that searches for a specific text, and any value associated to that text will shift over to a certain column. I would assume I would need to use an If Then statement, but like I said, I am very...

<tbody> ID FULL ID LEFT ID RIGHT ID TYPE 1234 1234 1 2345 2345 0 3456 3456 0 6234 6234 1 4657 4657 1 6879 6879 1 1243 1243 1 5436 5436 0 7896 7896 1 4894 4894 0 </tbody> I am having trouble getting the values in Column "Type". So the idea here is that...

Hello, I am having an issue with an Nested IF THEN statement. I am hoping you can assist. The formula i have is located in DR4 `=IF(DF4="0","",IF(R4="PC",((S4+1.5)*(T4+1.5)*(U4+1.5)-(S4*T4*U4)),((S4+1.5)*(T4+1.5)*(U4+1.5)-(S4*T4*U4))*V4)/1728*7.48) the goal is to look at DF4 if its zero...