Hi,

I've posted a couple of questions recenly and got great help back and at the end of last week and I though I had what i wanted. But not the case.

I have a simple user form to collate some simple details. When these details are published to the spread sheet I have two sequences I'd like to have with them. The first is an overal sequence for each new entry (which works fine). The second I want is for a sequence to each Workstream. The work stream itself is in column C for each new row and populaed via the form. This is what I thought would happen, using the workstream value I search for the last occurence, get the value and remove the last five digits from the right and add 1.

But what happens is that it only ouputs the workstream name plus 00001. (Workstream00001, rather than increnting it based on the last occurance). I wonder if someone can give me some pointers as to where I am going wrong. Or hould I give up and go back to UNIX.



Please Login or Register  to view this content.