excel & vba & nested if

Hello, I have been trying to set up an automated email system based on expiration dates of research supplies. I have set up a code in VBA that can send out an email to the appropriate employees based upon when the supplies have expired. I would now like to include specific cell data from excel...

Hi, I’m hoping someone can help me out, on the Greater than 5>< tab I would need it to appear as “>5” if it’s greater than 00:05:01 (HH:MM:SS) apparently VLOOKUP won’t work on it even though It’s on the same format; your help is greatly appreciated <tbody> Longest Wait Time Service Level...

Hello, I have a checkbox that changes the color of a cell if it is checked. The user can't print the page until a value is entered into the highlighted field. Both the checkbox and restrict printing modules are working properly. How do I change the color of the highlighted field once the user...

I am learning VBA, I have data in sheet1 18 rows with 5 columns and Sheet2 3 rows with 8 columns I would like to loop data and print in NOTEPAD like, Rows 1 - 6 from sheet1 then Row 1 from sheet2 Rows 7 - 12 from sheet1 then Row 2 from sheet2 Row 13 - 18 from sheet1 then Row 3 from Sheet2, so...

#2[/URL] 42729]I have an excel file with a template to write it in Notepad with certain format, #2[/URL] 42729] #2[/URL] 42729]And the Output in notepad is, #2[/URL] 42729] #2[/URL] 42729]Below is the code which I tried and also got help from stack overflow, but I am not able to compose the...

Hi Team, I have been brainstorming this from past couple of months. I work in reporting team and during month end I pull all incident report which has changed priority from P1-P2-P3-P4, P2-P3-P4 or P3 to P4. Currently, I am performing it manually (4000+ count). Below is the sample excel where I...

Hello, I'm trying to create a selection tool when based on the criteria selected more rows become un-hidden. So far I have the below for my code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'For On Property' If Range("C7").Value = "YES" And Range("F7").Value = "NO" Then...

Hi Team, Am having a macro to import multiple csv file and to consolidate it as a single sheet. No my requirement is to import only files modified from 2PM to 11 PM. Can any one please help.

Sub ShowStockWithRisingPotential() Dim sheet As Worksheet Dim CurrentRowNumber As String Dim RisingValue As Double, RisingThershold As Double, RisingTrend As Double, Result As Variant, i As Integer, j As Integer, Stock As Long CurrentRowNumber =...

I am a newbie in vba and I am trying to get in vba all dates between 2 dates, for example I will call the function with the parameters 01-01-2015 and 15-01-2015, and I will get in return an array with all the dates possibles, i.e : This is the Data that I have; <tbody> ID Start Date End...

Hi guys, I new to excel and I'm having problem how to program it to my vba.. I have worksheet, that contain column: DATE, PIECES, and CODE THINGS <tbody> <tbody> DATE </tbody> <tbody> PIECES </tbody> <tbody> CODE THINGS </tbody> <tbody> 01/01/2015 </tbody> 7 <tbody>...

Hi, this has been driving me crazy and i am unable to find a formula to drive me the result. Please refer to the below case. <tbody> A B C D e 234563; 234575; 564543 Apple Yes 234575 (Apple) 223344; 278923; 232324 mango No 232324 (Mango) 123456; 567890 banana Yes 123456 (Banana)...

Hi, I am working on a problem in which I have an array of start and stop dates (mm/dd/yyyy) and time (24 hour format) and a total cost, for example: Start date Stop Stop Total Cost Row1 3/4/2016 14:00 3/6/2016 08:00...

So I've got a big stock spreadsheet with multiple tabs to seperate catergories and within each tab is a table. each containing items, each with multiple sizes and then the quantity etc. for example one group of items I have is <colgroup><col span="2"><col></colgroup><tbody> Item Code Size...

Hi, I am new to VB and would like to know how I can change my excel formula to VB? this is my formula: =IF(A3="Telkom","TGE",IF(ISNUMBER(SEARCH("mobile",A3)),"MOB",IF(ISNUMBER(SEARCH("ambulance",A3)),"TSC",IF(ISNUMBER(SEARCH("toll free n",A3)),"TSC",IF(ISNUMBER(SEARCH("toll free...