Choc, I'm not really sure what you meant, but here's a macro that will probably give you a hint. For this macro to work as an autofill, you have to assign it to the ENTER key in the format you are using (Edit, Format, Edit > Tools, Keyboard.) Make sure the macro only works when the ENTER key is pressed when you are editing a record (Context: Editing Records).
So, what happens is this. You enter a number, and you press ENTER to go to the next line. The ENTER key activates the macro, which looks at the number you just typed and compares it with a list of numbers that should have text next to them. If your number matches one of the numbers in the list, the corresponding text will be typed next to the number. If not, the macro will simply type a carriage return.
Try typing one of the numbers in the list (after each "case") and you'll see the text "This is line 1" etc. appear after the number. Type any other number and nothing will happen.
Of course you can change the macro so that it contains your numbers and text.
str = trim(ClipboardText)
Select case str
str = str & " this is line 1"
str = str & " this is line 2"
str = str & " this is line 3"
str = str & " this is line 4"
TypeText str & vbCrLf