Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Normal
I think the VLOOKUP suggestion is your best bet. Leave VBA to number crunching, and prettify your worksheet manually.