Automatic Ruining Serial Number Against Multiple Reference in Excel

Hi,

Sheet 1

A

Data

Slno:5456
Branch Date Serial No Branch: Lucknow
BHOPAL 12.05.2015 5456 Date:12.05.2015
JAMMU 5457 Next i have select any branch (Hyderabad) i want automatic serial No
VARANASI 5458 incase if any printing problem i would like a previous branch serial No.
DEHRADUN 5459
LUCKNOW 5460
GHAZIABAD
KOLKATA
BHUBANESWAR
PATNA
SILIGURI
HYDERABAD

we have many branches around us.whenever we dispatched to a branch we make a note of continues serial number manually for each time/day.

we begun with new continues set of serial number each day/time.(E.g. Day 1 serial Number 1 to 9, Day 2 to 10 to 25so on and on)

The branches maybe vary therefore whatever branch i have choose i want continues serial Number next to the branch.

if in-case there is a problem(printing problem again re-print) and i would like a previous serial no against date and branch.

pl help me. file attached.