Use form submission to enter data both in the form and not in the form

I have a form i designed to allow the user to quickly enter a

1. Customer
2. Date
3. Price
4. Quantity

by color. But I ran into a problem. I didn't consider the section in CUSTOMERPURCHASEDATABASE that supposed to store the data didnt have the form in mind.

Please help me make the form enter the same date and customer name on each line where the user listed a price and quantity for each of the colors. If there was no info entered for any of the colors it just skips it.

I've attached the spread sheet. Please help me figure this out because my plan B requires a lot of work that might not work.

Loop through the checkboxes for the colours and for each one that is checked call the EnterData sub, passing the colour, price and quantity.