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 s...
Thanks Riny_van_Eekelen, you've been so helpful. I really appreciate it! What was the error as you didn't attach the updated file :).
So by using VLOOKUP I can set up a separate sheet with all the preset routes and miles and pop that formula in the mileage column on the original sheet.
TomStyles Sorry! See attached. I had forgotten to include the last part (FALSE) in the formulae.