Search:

Type: Posts; User: Scott T; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.10 seconds.

  1. Re: Way to use type ahead in a validation list?

    This video show how to type in part of a name and have the list update. It used the new dynamic arrays

    https://youtu.be/Z-h2UER3b_0

    If you do not have the new dynamic arrays then you will can...
  2. Replies
    5
    Views
    91

    Re: Lookup and Populate cell

    I assume you want to use the current year for the number of days in Feb since there are sometimes leap years.

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color:...
  3. Replies
    3
    Views
    114

    Re: User Name Based Drop Down

    Sounds like you want depended data validation.

    see video for details

    https://youtu.be/So51kA_LVK8
  4. Replies
    3
    Views
    105

    Re: Constantly Changing Password Macro

    If I understand what you want correctly you could have a input box where the user types in the password.

    something like


    Sub prosheet()
    Dim pw As String
    pw = InputBox("enter password")...
  5. Replies
    3
    Views
    580

    Re: Trying to test HTML Maker

    You should have the need code in your clipboard so when you come the forum you can start/reply to a thread and past the code.
  6. Thread: Lookup Help

    by Scott T
    Replies
    2
    Views
    96

    Re: Lookup Help

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px"...
  7. Re: Protecting Sheets but allow Macro to run....

    In your code you can unprotected the sheet(s) at the start and then protect them at the end.

    see
    http://learnexcelmacro.com/wp/2014/06/protect-unprotect-sheet-using-vba/
  8. Re: Can I copy only certain data from a cell?

    Does this do what you want?
    Note this assumes the date is always 10 characters. The result is text not excel time.

    =RIGHT(Sheet1!A1,LEN(Sheet1!A1)-11)
  9. Replies
    13
    Views
    215

    Re: Copy cell Next from Cell with Text "True"

    How is it not working?

    Try

    Sub copypast()
    If UCase(Sheets("copy").Range("D5")) = "TRUE" Then
    Sheets("past").Range("G2") = Sheets("copy").Range("D5")

    End If
  10. Replies
    15
    Views
    495

    Re: Timeline Conditions

    What happens if it is not under capacity? If row 5 did not start on Jul 31 but on Aug 1(the listed start date) then using the 25%,50%,100% you would be 300 short on Aug 7 the planed last date.
  11. Replies
    15
    Views
    495

    Re: Timeline Conditions

    How exactly to you come up with these numbers?
    you have a start date of 8/1 but it starts on 7/31?
  12. Replies
    15
    Views
    495

    Re: Timeline Conditions

    Could you post a sample of your data and the results you want.
  13. Replies
    2
    Views
    137

    Re: how to make my array formula dynamic

    You could use dynamic named range

    https://www.excel-easy.com/examples/dynamic-named-range.html
  14. Thread: Index / match

    by Scott T
    Replies
    4
    Views
    96

    Re: Need help with INDEX / MATCH

    Match would find the first occurrence of Federal and still return 12,069.

    You should only get the N/A if one of the words you search for is not found or you do not use CTRL+SHIFT+ENTER.

    If you...
  15. Thread: Index / match

    by Scott T
    Replies
    4
    Views
    96

    Re: Need help with INDEX / MATCH

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px"...
  16. Replies
    5
    Views
    195

    Re: Alert - First Monday of the Month

    Try
    I assume you want E2 blank if it is not the first Monday

    =IF(TODAY()=EOMONTH(TODAY(),-1)+1+CHOOSE(WEEKDAY(EOMONTH(TODAY(),-1)+1,2),0,6,5,4,3,2,1),"project","")
  17. Re: Date Formula Result to not return a weekend day

    does this do what you want?

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  18. Replies
    1
    Views
    80

    Re: Adding Spaces into Text

    you need to add the spaces where you want them.

    for example

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse;...
  19. Replies
    2
    Views
    62

    Re: Use ampersand to change year in formula

    When you do that it turns into text and is no longer a cell reference look at the indirect function.

    Note that indirect does not like closed workbooks so Sales report2019 will need to be open when...
  20. Re: If Statements Based on Number of Decimal Places?

    To get only the digits after the decimal I used the mid function since I do not know how many digits there are I just used a large number.
  21. Re: If Statements Based on Number of Decimal Places?

    Maybe something like
    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  22. Re: Conditional formatting formula for date depending on name

    Maybe something like
    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  23. Replies
    6
    Views
    165

    Re: Array Formula Help

    your cell reference should not have quotes around it. Should be

    =VLOOKUP(N4,...
  24. Thread: Sumifs

    by Scott T
    Replies
    12
    Views
    409

    Re: Sumifs

    Try
    where P3 has the start date and Q3 has the end date
    adjust ranges as need

    =SUMIFS(M1:M146,A1:A146,">="&P3,A1:A146,"<="&Q3)
  25. Re: Please Help - Getting a SUM with a cell when using the IF(OR Statement

    You do not need the "" around the 8. Putting a number in quotes turns it into text.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4