Thread:Chriscar2/@comment-30967537-20170319175342

Hi Chris,

Wish I'd done this search about 3 months ago, would have saved myself a LOT of time!

I wanted to know how much I still had to spend so I created an Access database based on the information I found on RR3 Wiki. That took me a few days but now that it's done and because I've now (should have done it earlier!) created a Car Entry form, adding new cars and upgrades and editing existing cars is a breeze.

Some of my team-mates wanted to know if there was a way they could calculate how much they still needed to spend for a full fully-upgraded garage so I built a spreadsheet using data from my database. I used Excel 2013 but stuck to formulas. I know it could be faster if I used specific cell ranges but I used A:A ranges to make it easy for them to add new cars and upgrades. Is this something you've already done or do you want to have a look?

I'm now going to have a look at PowerQuery for Excel which I never knew about!

Nick 