if then else

I used to use if then else in Crystal Reporting but haven't figured it out in Excel. I have a column with rows of cells with different percentages in them, let's just say Column Q rows Q2 through Q30. In Column T, T2 through T30 I would like to put a number based on whats in Q. Tte numbers in Q...

Hello, I'm having some trouble getting an If…Then…Else Statement to work using multiple ElseIf conditions. Currently, it will only take action on the first condition and none of the others. A1Digital Library2hoopladigital3openlibrary4lacountylibrary5GlendaleLAC I commented out the Else portion...

Hi all, I've been looking for a solution to my problem for way too long so I hope someone here can help. From an Excel workbook, I run a macro that will open/activate an existing Word doc, copy some info from the spreadsheet onto this word doc, then, if the user requires it, another existing...

https://drive.google.com/file/d/1ly_TVkX804dgmNfMscyBRXCAs3vtx-jp/view?usp=sharing I have built a sheet that helps me manage my inventory. I have a BIN REPORT and REC INPUT tab where i update information which then feeds to my CONSOLIDATION tab which helps me minimize warehouse space. I even...

Hi Power Users! I am very new to Power Query, but an advanced Excel user. I am starting to get into Power Query and using data tables across a number of workbooks. I have a column in my data table that should be a number however, sometimes it will be a text due to a letter being added to the...

I have macro in VBA that uses a data set in excel. Then it filters all but one specific vendor. Everyone else is removed from that data set. Unfilter. Then I'm left with headers only and no data lines (line 2 and below) or I'm left with header data and data in lines 2 and usually more. Then...

<colgroup><col style="mso-width-source:userset;mso-width-alt:9325;width:191pt" width="255"> <col style="mso-width-source:userset;mso-width-alt:2157;width:44pt" width="59"> <col style="mso-width-source:userset;mso-width-alt:10532;width:216pt" width="288"> </colgroup><tbody> SHELBERT...

Hi Everyone, I have TextBox1 in a userform. When somebody opens up the userform the textbox is prepopulated with a number already in it (.31), however I did leave the option for the user to change this number if needed. The reason why there's a decimal because when the number is submitted on...

Hello, I would like to firstly check if a specific sheet exists, then if TRUE, extract a value from that sheet. I do this in two stages: Step1:- Cell B3 - If sheet "JAN2018" exist, then return 0, else FALSE - =IFERROR(INDIRECT("JAN2018"&"!A1"),"FALSE") Step 2:- Cell B5 - If cell B3 = 0...

I am failing dramatically at writing the code for this, what I thought would be a simple macro. This initial process is the following: IF E2 begins with “006***” THEN return the last 8 characters in the string in U2, only IF the final 8 characters are numbers, THEN return “N/A” in U2, & IF...

Hello I am using open office calc (apache) and in my document I have a number of dropdown lists e.g dropdown list 1 has the following entries: Not Selected Yes No In another worksheet of the same document I ask various questions (say to some sales people) e.g (in cell A6): Q1) Would you like...

Hello dear Excel users, I wrote a macro that is creating 3 pivot tables, all in separate sheets, from the same table (table1) in the sheet RAWDATA. The last pivot table must be created only when at least 1 row in table1 in column K is containing the word TRUCK. If no rows exist with the word...

I am trying to conditionally format a cell based on other conditional formatting in a range of cells. Ex. I would like cell E3 to be: Red if any cells (O3, T3, Y3, AD3, AI3, AN3, AS3) are Red IF NOT THEN Yellow if any cells (O3, T3, Y3, AD3, AI3, AN3, AS3) are Yellow IF NOT THEN Green if any...

Hi all. I have a dilemma I hope you can help me with. I am not great at VBA so bare with me. I need a macro that will look in an individual cell and work out what to do with its contents. There could be a number, or a text and a number. the column is essentially serial numbers. for eg. item 123...

Hi all, I am trying to correct an error on many spreadsheets (100+) we have located out on a network drive. I had a formula that was incorrectly written and needs to be updated. I've written the code below to be used in a loop macro that opens up each spreadsheet and updates the formulas (if...

Hi, Please help or advise. I am trying to write an IF statement that allow me to autofilter my data list. My code is to use string function to detect a certain text in a cell (D3), so basically if D3 contains "77" then filter with a condition, else filter with another condition. Below is how my...

Hey Everyone, I'm brand new to VBA, and I think I've exhausted my efforts in trying to figure out my problem. Our VBA expert left the company, and I was tasked with optimizing a tool that he created which we use to send email correspondences to candidates. The code works as is, but my manager...

I would like to run the below code only when there is no "x"'s in the following ranges: ActiveSheet.Range("C16:C633") Sub msgReset() Dim iRet As Integer Dim strPrompt As String Dim strTitle As String Dim num As Integer Dim var2 As String var2 = "x"...

I would like to apply the following code (only if the shape is not already placed in the location): Private Sub Workbook_BeforeClose(Cancel As Boolean) Sheets("Pricing").Shapes.AddTextBox(msoTextOrientationHorizontal, 807.3529133858, _ 5.2940944882, 632.6470866142...

Hi I am relatively new to VBA with basic knowledge and need help writing a macro.. I have text in column V of my worksheet, the value of cells in column V is either "Clear", "Pending" or blank "". I want to write a macro that will input the date the current date into columns U and W IF the...