Thanks for your help. Just to clarify, none of the rows or cells or protected.
A simplified version of the table is below. You will notice that each row has drop down menus. The issue arises from the addition of rows either at the end of the table or somewhere adjacent to the already existing rows. If I insert a row either above
or below an already existing row, the drop down menus are not copied to the new row.
Currently, the drop down menus are set to the default fields. However, after the user has selected the values for the below four items the rows will have data in them. So if I copy the row, the copy function will pick up the user selected values as opposed
to the default values. The copy will not pick up the drop down menus.
Please provide code that will insert a row (either above or below an existing row) that will include the drop down menus with the default values of "choose an item" or "click here to enter a date."
| Choose an item. |
Choose an item. |
Click here to enter a date. |
|
| Choose an item. |
Choose an item. |
Click here to enter a date. |
|
| Choose an item. |
Choose an item. |
Click here to enter a date. |
|
| Choose an item. |
Choose an item. |
Click here to enter a date. |
|