Reply To: Excel and Quantity Link Script

  • Doug McLean

    Member
    September 19, 2023 at 3:16 pm
    Points: 19,166
    Rank: UC2 Brainery Advanced Blue Belt IIII UC2 Brainery Advanced Blue Belt IIII

    Well at least someone else has found my frustration with Quantity Link when doing something for the finishing trades.
    We can’t set up and use a template, so it becomes VERY time consuming to set up.

    As others have said, export the data to a csv file and then use probably Excel’s most powerful tool, Power Query to do the heavy lifting. It’ll take you a while to learn it, but once you get it, its amazing.

    Both Vince and myself have some pretty cool workflows using PQ, so if you need some help, just ask.