I’ve been wanting to know how to do this for years but haven’t done the Google search until now :-) Thanks!

Also, I just discovered Sheetsu which is the winner for me because it allows you to keep everything in Google Spreadsheets which is the most maintainable.