Hi,

I am working on the following table to automatically generate a reference
number everytime a data is inputted. Please see below table:

Cust No. TA No SI date Amount Rate
RESULTING REF
008-018970 01 0500247 22-Sep-08 12,000,000.00 0.25% 01 0500247_0001
008-018970 01 0500247 22-Sep-08 12,000,000.00 0.25% 01 0500247_0001
050-101393 01 0500324 20-Oct-08 5,000,000.00 0.25% 01 0500324_0001
050-101393 01 0500324 20-Oct-08 6,000,000.00 0.25% 01 0500324_0002

Is there a formula or a VBS code that I can use to automatically generate
above reference number is such a way that below conditions are met:
a) format of ref no. ia TA No._#### - #-representing the sequential number
b) that when a set of information is repeated in a row it will generate the
same reference number as the previous number (see item#1 and #2 - it has the
same information for all the column therefore it will generate the same ref #)

Is this doable? Any help you may provide will be highly appreciated. THANK
you so much in advance.