Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    27
    Views
    560

    Re: Find all matches and consolidate them

    with small table(s) it can be automatic update
    with large (few million rows) - better manual
    you can do what you want of course :)
  2. Replies
    33
    Views
    570

    Re: Get External Data (long shot question!)

    sure, it will
  3. Re: Power Query - insert column by repeating single value from another query

    the same result with different way :)


    have a nice day
  4. Re: Power Query - insert column by repeating single value from another query

    maybe add custom column with table threshold #"Added Custom" = Table.AddColumn(Source, "Custom", each Table2), then expand
  5. Re: Struggling to produce report based on horizontal table.

    are you able to use Power Query?
  6. Replies
    33
    Views
    570

    Re: Get External Data (long shot question!)

    if you do what I said it will create new sheet with table
    I don't know structure of your old tax table so you need to compare them
    also I don't know which name you want to change
    I don't know how...
  7. Replies
    5
    Views
    39

    Re: Automated conversion from TXT

    did you try change .txt to .csv ? (try on copy)
  8. Replies
    33
    Views
    570

    Re: Get External Data (long shot question!)

    sure,
    Data tab - New Query - From Other Sources - Blank Query
    then you'll see Power Query Editor, find Advanced Editor and click it then replace code there with code copied from the post then Done...
  9. Replies
    33
    Views
    570

    Re: Get External Data (long shot question!)

    this is NOT vba, this is M-code for Power Query

    download the file, set refresh time (connection/properties) if necessary and that's all. It's ready-for-use
  10. Replies
    33
    Views
    570

    Re: Need help with Get External Data (long shot question!)

    did you try post #19 ?
    it's maintenance-free except re-define refresh time if necessary
  11. Replies
    6
    Views
    446

    Re: Power Query - Calendar Table

    Glad to help

    Have a nice day
  12. Re: Duplicate rows and fill in new columns based on master list

    with Power Query


    LocationProperty1Property2LocationProperty1Property2

    Xa
    1Xa
    1

    Xa
  13. Thread: Pivot Table

    by sandy666
    Replies
    10
    Views
    102

    Re: Pivot Table

    good to see that, it wasn't so hard, isn't it ? :)

    have a nice day
  14. Thread: Pivot Table

    by sandy666
    Replies
    10
    Views
    102

    Re: Pivot Table

    something like this ?


    SOURCEPIVOT

    ClientRestrictedClientRestricted

    aaa HARTaaa HART

    bbvfrbbvfr
  15. Thread: Pivot Table

    by sandy666
    Replies
    10
    Views
    102

    Re: Pivot Table

    you didn't see the picture ? this is a .jpg so you should see

    https://postimg.cc/cKQqyNWr

    or

    example video

    or
  16. Thread: Pivot Table

    by sandy666
    Replies
    10
    Views
    102

    Re: Pivot Table

    https://i.postimg.cc/jj1RfskQ/contains.jpg
  17. Thread: Pivot Table

    by sandy666
    Replies
    10
    Views
    102

    Re: Pivot Table

    Label Filters - Contains - HART
  18. Replies
    33
    Views
    570

    Re: Need help with Get External Data (long shot question!)

    or much simpler version with automated Year and Refresh on Open file


    let
    Source =...
  19. Replies
    33
    Views
    570

    Re: Need help with Get External Data (long shot question!)

    and this is a whole used M-code and formula

    A2:
    =YEAR(TODAY())


    let Year = (YR) =>
    let
    Source =...
  20. Replies
    33
    Views
    570

    Re: Need help with Get External Data (long shot question!)

    did you re-download the file?

    you need delete previous downloaded file and download again
    try again ;)
  21. Replies
    33
    Views
    570

    Re: Need help with Get External Data (long shot question!)

    In case with formula =YEAR(TODAY()) edit Query Year and change name of the Query Table to tblYear

    https://i.postimg.cc/3w078zFb/screenshot-125.png or re-download the file from post #11

    be aware...
  22. Replies
    33
    Views
    570

    Re: Need help with Get External Data (long shot question!)

    in A2 remove Data Validation list then insert: =YEAR(TODAY()) (you can use NOW() instead of TODAY() if you want)
    in Data tab - Connection - select connection [Query - Year] - Connection Properties...
  23. Replies
    6
    Views
    446

    Re: Power Query - Calendar Table

    look at https://www.mrexcel.com/forum/power-bi/1087524-power-query-get-fiscal-year-fiscal-month.html#post5226438 or https://exceleratorbi.com.au/build-reusable-calendar-table-power-query/
  24. Replies
    33
    Views
    570

    Re: Need help with Get External Data (long shot question!)

    ok, you've PowerQuery built-in

    so try this:

    Example

    don't open it in browser just download and open in Excel :)
  25. Re: Return a Suppler name from a text string

    is your spacebar damaged?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4