Excel Form - need macro to add multiple rows with data validation & conditional formatting

Hi,

The excel form looks like in the attachment. Each Product has multiple rows with cells containing data validation, drop down lists, instructions and conditional formatting.

excel form.png

For example if a quantity is entered, the form will highlight in red the other required cells to be filled out. Once the information is entered the red background will disappear. The "Description" field is limited to 30 characters. The "Part Number" and "Manufacturer" are restricted to selections from drop down lists.

I need to include the option of adding other Products as necessary, with all the product's information as specified in each of the 4 adjacent rows, but keeping the same parameters: data validation,instructions, conditional formatting and formulas.


Thank you for your help!