VBA Code or other to create new record on previous record input (no longer blank)

[johanbamberger]

I have a Input Form / Table for Data Entry which is presented to a client for completion. As the Table could be 5 to 100 entries long I can not compensate for the unknown about of required rows.

Each Table thus has a number of records provided, but needs to “grow” based on the data entry, to allow for all relevant data to be added to the Form / Table.

I need assistance on a mechanism (VBA Code or other) to achieve the following :

When the last row / record in the Table is not blank, then add a new row to the bottom of the table. The record is however not just a row, but actually a blank line and the data entry row (so two rows).

The details :

Table : A1:Q10

Headers : Row 2

Input Example : Row 4

First Record : Row 6

Last Record Row 8

*Between each Record / Row there is a blank row to adhere to the visual aesthetics of the form.

*Row 3 and 4 is the “temple” from which to copy.



The requirement :

If Row 8 is not blank, then add a copy of row 3 and 4 at the bottom of the table, as the next “new record” ready to be populated.

If Row 8, Column E has input (is not blank), the trigger the add of the new record.

If Row 10, Column E has input (is not blank), the trigger the add of the new record.

Any advise would be much appreciated.

J

 

[johanbamberger]

Anyone?