macro - number pattern

[realmfighter]

Hi,

I'm trying to create a macro which will go through 100 records in a table and edit the value in the following pattern
1A
1B
1C
2A
2B
2C
3A
3B
3C
etc. until 100C

What would the code for this look like please?

 

[Uncle Gizmo]

That's 300 records, You mention 100 records.

Do you mean you just want to update a single field to the values shown?

Does the field you want to update also supply the sort order? Identity?

 

[realmfighter]

Sorry, I meant 300 records. Yes, I would like it to update the field ("desc") to the value. I don't mind about the ordering.

Thanks.