I need to set up a spread sheet to help with a quarterly rebate claim (from shipping lines).

I would like it to be done on Excel that way everyone & they're dog will be able to use it!

Now i've had a play but i'm fucked if i can work out how to get the B/L numbers to run numerical?!? Also i'd need Ecxel to pick out dates per quarter, thus allowing to collate the info.

Any tips?

In the past we would have a sheet for each carrier, for each routing but i can work out the coding for that..........

Screen dump of whats needed info wise.