test

  1. B

    Slow database - only on network folder

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

    Changing charts based on cells

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

    sumproduct and index match help

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

    Downloading attachment from mailbox

    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,
  5. M

    Test of the content of a cell, which is a formula

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

    Submitted forms via IE

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

    small macro needed

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

    Boolean test for dependency between 2 cells

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

    indexing beyond what i know

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

    Link to another sheets based on cell value

    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?
  11. D

    Using slicers and pivot tables to pull data from multiple columns

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

    VBA Select Entire Row when cell is selected

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

    Index sheet lookup recent entry on subsequent sheets

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

    Short code- Expression wrong

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

    Underlying formula might be causing a problem with testing of =Today()

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

    Help With Calculating Test Results

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

    Summarise table based on value

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

    Simple Cash Book. Formula proble in Column K

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

    I NEED HELP for translate index/match function into vba code

    Hi, anyone please me save :(:( how do i translate this to a vba code =INDEX('16090540'!D2:D296,MATCH(MAX('16090540'!N2:N296),'16090540'!N2:N296,0)) what i have done is test =...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top