+ Reply to Thread
Page 7 of 7 FirstFirst ... 5 6 7
Results 91 to 101 of 101

Call in the Cavalry - 2019

  1. #91
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    7,302

    Re: Call in the Cavalry - 2019

    Trying to help the OP use Power Query to append tables. I feel as if some of the steps that I took to append the tables could be consolidated using the Power Query Advanced Editor and that some of the contributors here could be of more help in that regard than I.
    Note that the file's summary sheet lists 87 tables that will need to be appended although the sample file only contains two.
    https://www.excelforum.com/commercia...ml#post5146002

    Edit: This is a commercial services thread.
    Update: The OP has appreciated the thread.
    Last edited by JeteMc; 06-30-2019 at 09:38 PM. Reason: Added edit and update
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  2. #92
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    28,111

    Re: Call in the Cavalry - 2019

    FAO: Olly

    Could do with your PQ expertise/advice here: https://www.excelforum.com/excel-pro...ml#post5146460
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #93
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    5,520

    Re: Call in the Cavalry - 2019

    Quote Originally Posted by AliGW View Post
    FAO: Olly

    Could do with your PQ expertise/advice here: https://www.excelforum.com/excel-pro...ml#post5146460
    Done
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  4. #94
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    9,159

    Re: Call in the Cavalry - 2019

    Could use some help here?
    HTH
    Regards, Jeff

  5. #95
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,470

    Re: Call in the Cavalry - 2019

    I could keep going here but I feel like I am wasting my time.

  6. #96
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    7,302

    Re: Call in the Cavalry - 2019

    The linked thread is a "populate a calendar from a list" type request, and I imagine that a calendar similar to the one the OP wants already exists.
    https://www.excelforum.com/excel-for...ml#post5150708

  7. #97
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    28,111

    Re: Call in the Cavalry - 2019

    Data layout disaster - anyone fancy helping this member to get his data into a usable and unbreakable format? I'm off out, so can't help just now.

    https://www.excelforum.com/excel-for...eferences.html

  8. #98
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,470

    Re: Call in the Cavalry - 2019

    Could use help here.

    OP wants to combine two workbooks with different structures based on two columns.

    I suspect that this can be done with Power Query but it's beyond my know how.

    https://www.excelforum.com/excel-for...column-id.html

  9. #99
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    2013, Office 365 ProPlus
    Posts
    4,028

    Re: Call in the Cavalry - 2019

    My colleague with MAC laptop is on vacation and I can't test. Can someone with more MAC knowledge or access to MAC help OP?
    https://www.excelforum.com/excel-pro...cript-mac.html
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  10. #100
    Valued Forum Contributor
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 2010
    Posts
    1,070

    Re: Call in the Cavalry - 2019

    Copied to the thread the code he was using for zillow and he has now provided the API ID to run it,
    but not sure if I can take it from here and don't want to leave everyone else thinking I'm working on it and him with no answer - (if someone else would otherwise have answered it)

    https://www.excelforum.com/excel-pro...illow-api.html
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  11. #101
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    28,111

    Re: Call in the Cavalry - 2019

    I am pretty sure the OP's maths is wrong here, but I am not confident enough in my own assumptions to help him. Any maths experts want to help out?

    https://www.excelforum.com/excel-gen...in-2019-a.html

+ Reply to Thread
Page 7 of 7 FirstFirst ... 5 6 7

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1