Alright, so this seemed like the next logical step for the rollover method:
This one is kinda complicated, I admit. Unfortunately, I didn't really take the time to clean up the spreadsheet file for others to follow (I don't really have the time these days). Sorry. But try to take it apart - and ask me questions if you have them.
I've canvassed some other folks from the Excel community to see if they would want to do a video tutorial of this - and I think that's what it would take.
Have fun!
Mapper.xlsm
This one is kinda complicated, I admit. Unfortunately, I didn't really take the time to clean up the spreadsheet file for others to follow (I don't really have the time these days). Sorry. But try to take it apart - and ask me questions if you have them.
I've canvassed some other folks from the Excel community to see if they would want to do a video tutorial of this - and I think that's what it would take.
Have fun!
Mapper.xlsm
