Sequential numbering........................

Please can someone help me find a formuale...........I have a spreadhseet of data which is run daily which is uploaded into the GL. So, batch header 1 (below) has 3 lines to be uploaded. Batch header no. 2 has 3 lines to be uploaded and so on. See further below. On day 2 you run the same report and the batch header no. starts with 1 (see sequence no.6). I would like to create a formuale which gives the sequence numbers shown below (ie so on day 2, batch header no.1 is sequence no.6 which is a continuation of the previous day 1 batch). Day 3 batch no. would start with 1 and should be sequence no.11........

Thanks


Sequence Batch header no.
1 1
1 1
1 1
2 2
2 2
2 2
3 3
3 3
4 4
4 4
5 5
5 5
6 1
6 1
6 1
7 2
7 2
7 2
8 5
8 5
9 6
9 6
9 6
10 7
10 7
10 7
10 7

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic