Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.24 seconds.

  1. Replies
    6
    Views
    154

    Re: Returning Home

    Option Explicit


    Dim CloseTime As Date
    Sub TimeSetting()
    CloseTime = Now + TimeValue("00:00:15")
    On Error Resume Next
    Application.OnTime EarliestTime:=CloseTime, _
    ...
  2. Replies
    5
    Views
    77

    Re: Merging specific worksheets

    You should consider Power Query / Get and Transform. Any changes to the original data is automatically updated into the output.
  3. Re: VBA: Fastest way to determine last non blank row in column

    ....and Joe types faster than me. :)
  4. Re: VBA: Fastest way to determine last non blank row in column

    LR=Range("L" & rows.count).end(xlup).row
  5. Replies
    3
    Views
    122

    Re: Hide Data in Running Total Pivot

    https://www.excelforum.com/excel-charting-and-pivots/1286857-hide-data-in-running-total-pivot.html#post5178755

    crossposted
  6. Replies
    4
    Views
    129

    Re: VLOOKUP based on drop down list

    If it works, then why wouldn't it be ok. Afterall, it is your spreadsheet and you are the one that needs to be happy.
  7. Replies
    4
    Views
    129

    Re: VLOOKUP based on drop down list

    v
    C
    D
    E
    1




    2
  8. Replies
    10
    Views
    212

    Re: IF(AND with IF(OR

    =if(or(A1="True",B1="True",C1="True"),"True",if(and(A1="False",B1="False",C1="False"),"False","Unknown")))
  9. Replies
    5
    Views
    69

    Re: Transposing a data table

    Glad to have helped
  10. Replies
    5
    Views
    69

    Re: Transposing a data table

    An alternative is to use Power Query. Look at the link in my signature if you are unfamiliar with this concept. Here is the Mcode


    let
    Source =...
  11. Replies
    12
    Views
    489

    Re: Macro to Combine Data from all tabs

    crossposted: https://www.excelforum.com/excel-programming-vba-macros/1286684-macro-to-combine-data-ranges-from-multiple-tabs.html#post5177939

    Please read: ...
  12. Replies
    12
    Views
    280

    Re: Combine Multiple Worksheets

    Have you considered using Power Query. Quick and simple to achieve what you are looking to do. Look at this video.

    https://www.youtube.com/watch?v=LSDQGWdgNJs
  13. Replies
    12
    Views
    489

    Re: Macro to Combine Data from all tabs

    Here is a MrE video that should walk you through the steps. Fairly simple and easy to follow.

    https://www.youtube.com/watch?v=LSDQGWdgNJs
  14. Re: Update prices automatically on a specific date

    Can you show us a sample of your data before and after. Does not need to be many records, but enough to be representative of your worksheet
  15. Replies
    12
    Views
    489

    Re: Macro to Combine Data from all tabs

    Without seeing your data, it is difficult to provide a PQ solution. If you are interested in a PQ option, suggest you upload a sample file to a third party location such as Dropbox or Box.net. Be...
  16. Re: VBA Move Data to different Worksheet if specific cell not empty

    crossposted: https://www.excelguru.ca/forums/showthread.php?10168-Help!-Transfer-Data-from-a-few-cells-basee-on-value-of-another-cell-in-that-row

    and
    ...
  17. Replies
    12
    Views
    489

    Re: Macro to Combine Data from all tabs

    Have you looked at using Power Query. This is a very simple step in PQ which the Excel team developed to do just this.
  18. Replies
    1
    Views
    87

    Re: How To VBA Code To All Worksheets?

    Option Explicit


    Sub CleanUp()
    Dim ws As Worksheet
    For Each ws In Worksheets
    With ws
    .Value = Evaluate("if({1},trim(clean(substitute(" & .Address & ",char(160),""...
  19. Re: Counting records in 1 column based on another

    Another option. Not as simple as Sandy but still works


    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID",...
  20. Re: Power Query - Pivot with multiple values

    If this presentation works for you, then use the Mcode shown beneath it in Power Query

    Data Range

    <tbody>


    A
  21. Re: Combine multiple row into one with line breaks using sql

    How about importing your table into Excel and creating a Pivot Table.

    Data Range

    A
    B
    C
    D
    E
    F
  22. Re: Macro to copy last row to next row, Formula and format

    I am a bit confused. Are you wanting to copy the data in columns A to I to the next row or just the formula in column A. Your request is not clear on this matter.
  23. Replies
    3
    Views
    92

    Re: Pivot Table Dates

    Inserting the data into a Pivot Table gets the following results. Then using simple excel subtract one value from the other for a difference

    Data Range

    A
    B
    C
    D
    E
    F
  24. Replies
    3
    Views
    92

    Re: Pivot Table Dates

    Your sample data (really need to see more data in your sample example) does not represent your explanation. I am confused as you have fields in your explanation that are not shown in your example.
  25. Replies
    3
    Views
    98

    Re: Linking worksheets

    ='worksheetname'!$A$1

    Add the exclamation mark
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4