Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.10 seconds.

  1. Replies
    2
    Views
    73

    Re: VBA Copy Row based off cell value

    Try

    Note: you do not need to activate sheet2 if you do not want to. Also you do not need the select the cell.

    Sub CopyRows()
    a = Worksheets("sheet1").Cells(Rows.Count, 1).End(xlUp).Row

    ...
  2. Re: VBA Code to change the font in a block of cells to white

    Try


    Sub CopyOffsetPaste()
    Dim lr As Long

    Sheet1.Activate

    Range("b2").End(xlDown).Offset(2, 0) = "Let's get this party started!"
  3. Thread: Pulling data

    by Scott T
    Replies
    2
    Views
    141

    Re: Pulling data

    Is this 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:...
  4. Replies
    5
    Views
    119

    Re: IFERROR Formula help

    IFERROR(value, value_if_error)
    If value does NOT return an error then the result of value is displayed.
    If value does return an error then value_if_error is returned.

    for example...
  5. Replies
    5
    Views
    119

    Re: IFERROR Formula help

    Your last iferror does not have a value-if-error that is the value to return if there is an error
  6. Re: Index Match Return Second Column, not first

    <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. Replies
    3
    Views
    120

    Re: Drop Down List Based On A Cell Value

    In Data validation
    pick list
    Where I1:I2 is the list for over 10K and H1:H2 is the list for under.
    You did not say what should happen if it is equal to 10K. So if needed change from > to >=.

    in...
  8. Replies
    1
    Views
    104

    Re: SUMPRODUCT / INDEX MATCH Question

    Since this formula does not reference the states on sheet 1 you will need make sure it refrences the correct cities on sheet 2. If they are listed in the same order you can copy across.
    ...
  9. Re: Data Matching Names from One Spreadsheet to Another

    Try

    <TBODY>

    A

    B

    C
  10. Replies
    9
    Views
    288

    Re: Calculating elapsed hours with weekends.

    RED= start date
    Blue= end date
    F2:F7 = holiday list

    ...
  11. Replies
    5
    Views
    168

    Re: IF and MID and ELSE

    You can use OR

    =IF(OR(MID(B18,2,8)="01330701",MID(B18,2,8)="01732401",next sequences goes here,.. ),"11-13 hours","")
  12. Re: Hello Excel gods Please how can I convert a PDF file to Excel is there a good way to do ?

    In Acrobat under the File menu select "Export to" then "Spreadsheet" then "Microsoft EXCEL workbook"
  13. Re: Hello Excel gods Please how can I convert a PDF file to Excel is there a good way to do ?

    If you have Acrobat then then you can export it as a spread sheet.
  14. Replies
    3
    Views
    173

    Re: Fill blanks macro

    Select the area and then hit F5 to bring up the go to box.
    Select Special...
    Then Select Blanks
    Type what you want in the cells then press CONTROL and ENTER
  15. Replies
    9
    Views
    288

    Re: Calculating elapsed hours with weekends.

    Forgot to account for if it is a work day but before 6AM this should cover that.

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

    Re: Calculating elapsed hours with weekends.

    Try
    <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"...
  17. Replies
    19
    Views
    808

    Re: Match function in reverse direction

    If match is working in reverse then the line with here would be 1 and the row above would be 2...
    So is it just the direction of the lookup that is reversed are both the direction and the row...
  18. Replies
    9
    Views
    258

    Re: Help conditional formatting not working

    If you want code to run automatically you can use a change event.
    This should be put in the sheet module.


    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target,...
  19. Replies
    9
    Views
    258

    Re: Help conditional formatting not working

    If you are willing to use VBA then this should work


    Sub checkdups()
    Dim rng As Range
    Set rng = Range("A2:A310")
    For Each cell In rng
    For Each mcell In rng
    If cell = mcell And...
  20. Replies
    1
    Views
    147

    Re: How do i calculate margin cost

    Gross profit margin = (Net sales-Cost of goods sold)/ net sales

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse:...
  21. Re: AutoFit Row and add 5 to row height via VBA

    This will auto fit row 7 then add 5 to the height. change to fit what you need.


    Sub adjrowheight()
    Rows(7).AutoFit
    myheight = Rows(7).RowHeight
    Rows(7).RowHeight = myheight + 5

    End Sub
  22. 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...
  23. Replies
    5
    Views
    216

    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:...
  24. Replies
    3
    Views
    235

    Re: User Name Based Drop Down

    Sounds like you want depended data validation.

    see video for details

    https://youtu.be/So51kA_LVK8
  25. Replies
    3
    Views
    190

    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")...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4