Data Entry - Write to next cell & next blank line
 

I am trying to use a data entry form to write a new data line into the next
blank line starting at cell A12 and ending at ending at cell AG12. There are
a total of eleven(11) data entry lines available. I have been using the
following code but I am having trouble with a) writing data to cells B12 to
AG12, and b) how to write a new record to the next new line starting at A14
to AG14. COuld someone help me out or point me in the right direction.

P.S. I hope the formatting comes out okay.

A1 - blank B1 C1
A2 - blank B2 C2
A3 - blank B3 C3
A4 - Header 1 B4 C4
A5 - Header 2 B5 C5
A6 - Header 3 B6 C6
A7 - Header 4 B7 C7
A8 - Header 5 B8 C8
A9 - blank B9 - Header 6 C9 - Header 6
A10 - blank B10 - Header 7 C10 - Header 7
A11 - Header 8 B11 - Header 8 C11 - Header 8
--------------------------------------------------------------------------
A12 - Data Line 1 | B12 - Data Line 1 | C12 - Data Line 1A |
|
|-------------------------|
A13 - Data Line 1 | B13 - Data Line 1 | C13 - Data Line 1B |
--------------------------------------------------------------------------
A14 - Data Line 2 | B14 - Data Line 2 | C14 - Data Line 2A |
|
|-------------------------|
A15 - Data Line 2 | B15 - Data Line 2 | C15 - Data Line 2B |
--------------------------------------------------------------------------
~ ~ ~
--------------------------------------------------------------------------
A32 - Data Line 3 | B32 - Data Line 3 | C32 - Data Line 3A |
A33 - Data Line 3 | B33 - Data Line 3 | C33 - Data Line 3B |
--------------------------------------------------------------------------
A34 - blank B34 - blank C34 - blank
~ ~ ~
A47 - blank B47 - blank C47 - blank