T
Tony
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
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