I'm on xl '03.

I am creating an order form that utilizes several dependent data validation
lists (aligned in a row) to narrow down what product at what price, etc. I
have 15 rows, so the user could order up to 15 products.

They begin by selecting an item in column D. and the rest goes from there.
Obviously, if they change the item in Column D, the other columns do not
automatically clear. I need the active row to clear itself each time the user
changes the item.

I can accomplish this with a recorder macro or worksheet_change(ByVal Target
As Rage) for one row, but I can not figure out how to get this same principle
to apply to all 15 rows.

IN ADDITION:
I need to allow the user the option to select "Misc" in column D and type in
their own product information and pricing (which will erase my formulas in
those columns).

If they change their mind and want to select another item in column d, the
dependent validation lists and vlookup formulas need to be reinstated
somehow.

Is that even possible?