Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds; generated 55 minute(s) ago.

  1. Re: Struggling to produce report based on horizontal table.

    are you able to use Power Query?
  2. Replies
    31
    Views
    486

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

    Re: Automated conversion from TXT

    did you try change .txt to .csv ? (try on copy)
  4. Replies
    31
    Views
    486

    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...
  5. Replies
    31
    Views
    486

    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
  6. Replies
    31
    Views
    486

    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
  7. Replies
    6
    Views
    414

    Re: Power Query - Calendar Table

    Glad to help

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

    with Power Query


    LocationProperty1Property2LocationProperty1Property2

    Xa
    1Xa
    1

    Xa
  9. Thread: Pivot Table

    by sandy666
    Replies
    10
    Views
    96

    Re: Pivot Table

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

    have a nice day
  10. Thread: Pivot Table

    by sandy666
    Replies
    10
    Views
    96

    Re: Pivot Table

    something like this ?


    SOURCEPIVOT

    ClientRestrictedClientRestricted

    aaa HARTaaa HART

    bbvfrbbvfr
  11. Thread: Pivot Table

    by sandy666
    Replies
    10
    Views
    96

    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
  12. Thread: Pivot Table

    by sandy666
    Replies
    10
    Views
    96

    Re: Pivot Table

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

    by sandy666
    Replies
    10
    Views
    96

    Re: Pivot Table

    Label Filters - Contains - HART
  14. Replies
    31
    Views
    486

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

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


    let
    Source =...
  15. Replies
    31
    Views
    486

    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 =...
  16. Replies
    31
    Views
    486

    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 ;)
  17. Replies
    31
    Views
    486

    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...
  18. Replies
    31
    Views
    486

    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...
  19. Replies
    6
    Views
    414

    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/
  20. Replies
    31
    Views
    486

    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 :)
  21. Re: Return a Suppler name from a text string

    is your spacebar damaged?
  22. Replies
    25
    Views
    514

    Re: Find all matches and consolidate them

    Pivot Table:
    just re-create PT, add filter CodC, DCscription to existing Qty and it will work

    Power Query:
    all steps you can see: Data tab, Show Queries, in Workbook Queries you will see four...
  23. Replies
    31
    Views
    486

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

    What is your Excel version?
  24. Replies
    25
    Views
    514

    Re: Find all matches and consolidate them

    again, what is your Excel version?

    try zip file
    no right click, just click
  25. Replies
    25
    Views
    514

    Re: Find all matches and consolidate them

    I added solution with PivotTables
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4