Search:

Type: Posts; User: alansidman; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.27 seconds.

  1. Replies
    3
    Views
    91

    Re: don't copy sheet with specific name

    What else is happening that would preclude this action. Need a bigger picture to understand the issue and how to solve.
  2. Re: Same Store Sales Analysis using Measures

    I don't know the term explicit measure. Suggest you post a mocked up version of what your expected results are.
  3. Replies
    2
    Views
    36

    Re: Concatenate(?) + Vlookup

    In K15 =K7+(K11/60)
  4. Re: Same Store Sales Analysis using Measures

    A pivot table as below

    Excel 2016 (Windows) 32 bit

    A
    B
    C
    D
    E
    F
  5. Replies
    1
    Views
    27

    Re: Filter search in MS Excel 2007

    Need more information. Some sample data showing before and after scenario.
  6. Replies
    11
    Views
    165

    Re: 'Next without for' compile error

    crossposted: https://chandoo.org/forum/threads/syntax-error.43013/#post-256516
  7. Re: Power Query Transforming Column with Actual and Budget Amounts

    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Category", type text}, {"Month", type text}, {"Amount", Int64.Type}}),...
  8. Replies
    5
    Views
    108

    Re: Count multiple worksheets qty of rows

    See if this air code works for you.


    Sub CountRows()


    Dim objFSO As Object
    Dim objFolder As Object
    Dim objFile As Object
    Dim ws As Worksheet
  9. Replies
    5
    Views
    108

    Re: Count multiple worksheets qty of rows

    are there more than one sheet in each workbook? Are all workbooks in the same directory? What is the full path name for the workbooks directory? How do you want the results published? Where?
  10. Replies
    5
    Views
    108

    Re: Count multiple worksheets qty of rows

    Option Explicit


    Sub CountRows()
    Dim ws As Worksheet
    Dim lr As Long
    For Each ws In Worksheets
    lr = ws.Range("A" & Rows.Count).End(xlUp).Row
    MsgBox (ws.Name & "...
  11. Replies
    3
    Views
    67

    Re: Counting cells by colour

    This will require a VBA solution and you will need to know the colorindex number for the background. See this similar request.
    ...
  12. Replies
    9
    Views
    170

    Re: Copy data from selection of sheets

    Have renamed Sheet1 as "Master". You can change this in the code if you desire.

    Option Explicit


    Sub cpypste()
    Dim ws As Worksheet, sh As Worksheet
    Set sh = Sheets("Master")
    ...
  13. Replies
    7
    Views
    173

    Re: Copy Duplicate Rows to a New Sheet

    Show us a sample of some data that you have so that we can see exactly what you need.
  14. Re: How to copy all rows above a specific text

    Just noticed an error in my code. Here is the correction


    Sub FindType()
    Dim c As Long, rng As Long
    Dim lr As Long, crow As Long
    lr = Range("A" & Rows.Count).End(xlUp).Row
    ...
  15. Re: How to copy all rows above a specific text

    Option Explicit



    Sub FindType()
    Dim c As Long, rng As Long
    Dim lr As Long, crow As Long
    lr = Range("A" & Rows.Count).End(xlUp).Row
    Set rng = Range("A1:F" & lr)
    For Each...
  16. Re: How to copy all rows above a specific text

    In what column is "Type" found?
  17. Re: Go to cell in specific column of the active row

    Option Explicit


    Sub Sapron()
    Dim r As Long
    r = ActiveCell.Row
    Range("AT" & r).Select
    End Sub
  18. Replies
    3
    Views
    72

    Re: Missing menu

    In the upper right hand corner of your excel sheet, there is an ellipsis (...), click on that and select how you want the ribbon to be displayed.
  19. Replies
    2
    Views
    45

    Re: How best to add category to age

    In C2 =IF(B2>18,"Adult", IF(AND(B2>11,B2<18),"Adolescent","Child")) and copy down
  20. Re: Macro to add 1 to 4th then 5th cell for 200 numbers

    Not a helpful response.


    Option Explicit


    Sub Hound12()
    Dim crit As Long, i As Long
    crit = Range("CD31")
    Dim lr As Long
  21. Re: Macro to add 1 to 4th then 5th cell for 200 numbers

    Option Explicit


    Sub Hound12()
    Dim crit As Long, i As Long
    crit = Range("CD31")
    Dim lr As Long
    lr = 926
    For i = 35 To lr Step 5
    Range("A" & i) = crit + 1
  22. Replies
    3
    Views
    200

    Re: I need help with a pick them worksheet

    deleted -- requirements are not clear to me.
  23. Replies
    4
    Views
    164

    Re: Date Conditional Formula

    I was hoping to accomplish this as a formula in Excel rather than a Sub in VBA. Is that ok?

    I'm curious. Why?
  24. Replies
    4
    Views
    164

    Re: Date Conditional Formula

    Option Explicit


    Sub Peteor()
    Dim crit1 As Date: crit1 = Range("A25")
    Dim crit2 As Date: crit2 = Range("B25")
    Dim c As Range
    Dim rng As Range
    Set rng = Range("H2:H14")
    ...
  25. Re: Delete rows if condition met without using filter

    crossposted: https://www.excelforum.com/excel-new-users-basics/1294929-select-and-delete-rows-without-using-filter-using-multiple-criteria.html#post5221816
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4