Thread:QuickNick/@comment-27370080-20170615135539/@comment-30967537-20170615160933

Hi Chris.

Yes, I "found" that page after looking a bit further.

Ok, so the data is there. The sale dates being listed as week numbers rather than dates is rather odd especially when you consider that the current sales table has one which started on 12th June (Monday this week) and the next starting on 17th June (this coming Satutrday) so they're obviously not once a week. That aside, given that the data is there I see no reason why it couldn't be used. But you'd still have to know the current and previous information to build the table in one step.

You could ...
 * Manually search the table for the relevant cars and edit the table. Seeing as how there's one car being added a week that wouldn't exactly take long to do.
 * Create a spreadsheet of the past entries (use Power Query to load the table and sort it by car and week, I just did it, takes seconds) and then maintain this.

I don't think it's worth the hassle of creating a special query to extract the data and then build the table ... but I'm happy to help out with anything PQ-related if necessary.

Nick