Forum Discussion
Help needed on formula/VBA for auto fill
Hi All,
First post here, so hello and glad to join in.
I'm trying to create a sheet so I can track my mileage for work. I travel to specific destinations on a regular basis so am hoping to set up a formula/VBA script that will auto fill the mileage for me.
So Say I travel from A-B-C-A that will always be 23miles.
What I'd like to do is set it up so when I put the Route Details in one column it automatically pops the miles travelled into another column.
Is that doable??
Many thanks in advance!!
Tom
6 Replies
TomStyles Doable, but don't think you need VBA for this. Choose one of several functions that can lookup the route information from one table (LOOKUP, VLOOKUP, INDEX combined with MATCH, XLOOKUP) and return the milage in another. It depends a bit on how your data looks like.
Riny_van_Eekelen Thanks so much for coming back to me. Data set looks like this:
Journey Date Details of Route Actual Mileage 01/10/2019 HO-BOD-HO 02/10/2019 HO-TRU-HO 08/10/2019 HO-FAL-HO I was thinking of setting the Route Details Column to a set dropdown list and then once I've clicked on the desired route I'm hoping the Actual Mileage cell will auto fill the correct mileage.
Many thanks
Tom
TomStyles Ooops. Edited my file as it contained a small error!
