I have had someone help me develop a form to catalog my 45 RPM Records. The
other forum was a little difficult to negotiate, and I really don't know how
to do any complex form development.

I am trying to get column "A" to autofill Line 1: "45-0001-A"; Line 2:
"45-0001-B", through Line? "45-9999-B".

I have had a friend to help me figure out part of the program, that the
other "User" on the other forum "Excel Banter", but I have tried to enter a
reply to the Forum, to include an Attachment .zip, and it's too large for the
Forum limitations.

This is what I have so far: Line 1: "45-0001-A"; Line 2: "45-0001-B", etc.
through Line 9983 showing: "45-4992-A". I need to complete autofill,
beginning with Line 9984 showing "45-4992-B", through Line ?: "45-9999-B".

I also need to insert two rows at the beginning, with Titles on Line 1;
Leaving
Line 2 (Blank), and Lock Lines 1 & 2. When I add the two additional lines,
fill in Line 1 with the Titles, and click on Line 3 to "Lock" lines 1 & 2,
some of the Lines that I have managed to "Autofill", delete two of the
existing catalog Line Items; for example: "45-0005-B" and "45-0006A" will
self-delete (this is for illustration purposes; I am not sure which two lines
will self-delete).

I have been working on this for three weeks, and I just can't figure out
what I am doing wrong.

Can someone help me complete developing my catalog?

Thanks,