1. danhendo888

    SUMIFS formula picking up all values instead of criteria

    https://1drv.ms/x/s!AvjBsEPEq12ngT3R9p-e8rqgVZkN?e=k7e4yd I have two columns. First column =age of invoice Second column = $ I want to do SUMIFS for invoices > 365 days E6 works fine for invoices 'Not Due' E7 should pick up $0.00 but instead picks up everything Not sure why..
  2. B

    Can I do this?

    I draft a bunch of fantasy football teams and would like to take all the players I have drafted (from about 20 drafts, 28 players each) place them into an Excel file to determine ownership percentages. Trying to determine my exposure to player. The app I use to do the drafts allows me to...
  3. S

    Hide rows or access only specific rows based on userform login

    I have a tricky question. I have a workbook I am using for a game about 1000 people will be playing. The workbook consists of several sheets but the only sheets users will have access to is a sheet called "Picks". Admin users will have access to all sheets so I already have a system in place...
  4. Y

    Project Workplan Dashboard

    Hi guys, I am very new to VBA and I am looking for some help with some code that would help me at work, basically I am looking to optimize a simple dashboard for my projects Workplan for the year. The table on "2019 Plan" shows the number of projected days and to the right of it the actual...
  5. S

    Hide rows using a userform login

    I have a workbook with 3-4 sheets. I havecreated a registration and a login userform. The registration userformconsists of a Reference number, Full Name, address, email, phone, etc. andallows each user to create a username and password for logging in later. Once registered, ALL of their...
  6. J

    For each and If with worksheet function

    Trying to find time gaps based off each cell and its offset (the next cell down) in a dynamic range. My error message right now is 'object required' in the if statement. For Each cell In picks() If WorksheetFunction.Abs(cell.Offset(-1, 0).Value - cell.Value) > 0.02083 Then do something ElseIf...
  7. F

    Sum automatically picks where there is either data in cell A or cell B

    Hi all, I need the sum in cell D of either cell A OR cell B + cell C. Cell A or Cell B does not always contain data. It's either there is data in cell A or in cell B. example 1: cell A = 250000 cell B = cell C = 120 cell D = 250000 + 120 = 250120 cell A = cell B = 350 cell C = 120 cell D =...
  8. J

    Filter Exact word from Columns having No. of strings VBA

    I am using below criteria to search exact string out of a column of string sCriteria = "*" & " " & Range("H" & i).Value & " " & "*" But it only picks up the word that is preceded and followed by a word.Even if I add space at the start and end of string. Is there any way
  9. D

    VBA code to randomly pick from a list of names

    Hi, I have this code that randomly picks a different name from a list. Sub CommandButton1_Click() Dim lrcd As Long SendKeys "%^{F9}" Range("H31").Copy 'Range("C2:C7").PasteSpecial xlPasteValues lrcd = Sheets("Sheet1").Range("E" & Rows.Count).End(xlUp).Row Sheets("Sheet1").Cells(lrcd +...
  10. JTL9161

    VLOOKUP plus Conditional Formatting

    Not sure if this is do-able or even clearly explain-able. I have a fantasy baseball spreadsheet that calculates the number of correct daily picks for 20 people I have each person picks labeled as the teams "2nd name" (i.e. Red Sox, Yankees, Mets, Dodgers) I then have the scores from each...
  11. B

    Formula Improvement

    Hi, I have a table of two types of product codes (finished products with associated sub-product codes. I want to be able to search the column of sub-codes and identify all the finished product codes associated, and then to use the results of that search to draw data from a separate table. The...
  12. L

    Graph Question

    I have a simple Spreadsheet with 3 Columns,"Date, Revenue and Cost." I have highlighted the 3 Columns as my Data for the Graph. I have deleted all the Rows that would be Saturday or Sunday. So column A has Jan 1-5, there is no Jan 6 or 7 and then picks up with Jan 8. However, the Bar Graph...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...