This sounds like a fun project! Can you attach a sample spreadsheet and I'll give it a go. Doesn't sound too difficult, but makes it more difficult to start from scratch.