test

Hi, how do I create a If Then Statement to compare ANY of the values in let's say cell B1-B200 to A1. See typically the If then Statement to compare a single value would be = if (B1>A1, "STOP", ""), but now we need to test B2 to 1, B3 to A1, B4 to A1.... and have a message stop if ANY of the...

I have a quite small database put on my companies network shared drives. The database is split into two files. The connection is set to IPADRESS\FILEPATH. I have huge problems that the database is very very slow when users works in it. I have searched for a long time for an answer to this, but...

This probably sounds familiar, but I have been rifling through google and herd all day to find a solution. Here is some background information: The spreadsheet is for trend analysis on tests. You put in the class number, number of students, and what version of the test they are on(there are 3...

So here is what I am looking to do I have a column of dates then a calculated number 1 2 or 3 I have test data and results, I want to calculate the total for the year with an equation but I need the test date to be the latest one so here, 2/10/18 uses 3 then 6/2/18 uses 8 Equation is like this...

Hello, I need an EXCEL VBA script which will perform the following operations: 1. Open my Outlook 2. Read mail with a particular subject line (let's say ' TEST MAIL') 3. Download the attachement from that mail to Desktop location. Please help me with the script. Thanks,

I need to create a product label concatenating the content of several cells... Now, some of them can be empty and other not... Let's imagine that I have in a cell the result of several other cells, concatenated... A1 contains "" or could contain a value B1 contains "" or could contain a value C1...

Hi all, I am trying to automate a number of forms we need to submit on a weekly basis with the same details. I have tried writing a VBA code for this however I get an error once i read the first elementbyid. Sub SubmitSpark()Dim IE As Object Application.ScreenUpdating = False Set IE =...

Hi, Can you please help me to create a small macro to calculate % in the background and then do a summation on the sheet. Let me explain further. I have 10 pupils and they wrote 3 tests. I must now calculate the results and report on how they did per test. There are 4 results brackets and I...

How can I test whether one cell is dependent on another? I tried the following, but does not seem to work: Function Depends(Cell_B As Range, Cell_A As Range) As Boolean If Not Intersect(Cell_B, Cell_A.Dependents) Is Nothing Then Depends = True Else Depends = False End Function

I am looking to do a sum of a bunch of data. I will do my best to lay out the file and what I am looking for. I have a sheet (line 1) with every day of the year in column B Also on that sheet, I have a 1 or a zero in column K On a different sheet (test), I have random dates (dates something...

Example: Cell B1 gets value from cell 'Sheet1'!K12 In cell A1 is a value (test) In cell B1 I want to have the value from cell 'test'!K12 Is this possible without using VBA?

<tbody> Test1 Test2 Test3 Test4 Name1 Score | 4 May Score | 4 June Score | 4 July Score | 4 Aug Name2 Score | 4 July Name3 Score | 4 June Score | 4 July Score | 4 Aug Name4 Score | 4 June Score | 4 Aug </tbody> Hi, I’m fairly new to the...

Do any you have away I can change the code below to have the entire row change to red instead of just the selected cell? Thanks as always Cells.Select Selection.FormatConditions.Add Type:=xlTextString, String:="(OBSOLETE", _ TextOperator:=xlBeginsWith...

Hi, I am looking at a document register system on Excel. I'd like sheet 1 to be the Index sheet. The Index sheet will look up the master "All forms and revisions list" and list all the forms with "Doc Ref numbers" beginning with "MF" and the most recent revision only. The master sheet with all...

Hi all. What is wrong with this code? It might be an expression issue. My code isn't running. Sub Test() Dim x As Long 'test range For x = 134 To 140 'instead of range, should I be using .cell("F" & x).Value? If ActiveSheet.Range("F" & x).Value <> ActiveSheet.Range("E" & x).Value...

In cell Z6 I have the following formula =IFERROR(INDEX(Input_Events,data!K3,2),"") that returns a formatted date (MM/DD). In cell AC6, I am performing the following test: =IF(Z6=TODAY(),"CALL","") When I have the current date (todays) in Z6, it returns a false test (""). If I change the...

Hi, I am trying to find a better way of calculating total metrics of our test results from various sets of tests. The cut down table and the text below shows how we are currently doing it, but the formula is going to be too long to do it on the next sheet so I am looking for a more simple way...

Hi, I have a table, names of people in column (A) and names of tests in columns B to Y. Each person can only do specific tests which is marked by the name of the test under the heading. If the person cannot do the test this cell is left blank. Is there a way I can select a specific person's name...

<tbody> a b c d e f g h i j k income expend bank Date Description Rec Income Vouch expend CHQ No Deposits Withdrawal balance Cash 1/1 B Forward 100.00 10.00 1/1 Test 1 1 10.00 1 100.00 20..00 2/1 Test 2 1 20.00 1 20.00 80...