Need help making data entry easier since some information is repeated on rows.

I have no experience with VBA. I am assuming I need it to make my data entry in excel easier. I appreciate any help or suggestions someone has to offer.

I have created a simplied example of my real-life problem. I am hoping if I can look at the base code I can convert it into my application. See attached.

I have no experience with VBA, so if you can provide assistance as to how to insert the code and run it, it would be greatly appreciated!

Summary of problem:

I have five columns in my spreadsheet: Product, Document #, Item, Category, Formula

-I want to make data entry easier since there is repeated data in columns A and B.

-There will always be 1 fruit entered. The number of veggies can vary from 1 or more.

-I am open to different solutions but I was thinking a dialog box that prompts the user to enter the Product, the name of the fruit and the number of veggies might be a good solution.

-Depending on the number of veggies specified, dialog boxes to specify name of each piece of each veggie

-Insert the formula in column E (B x 10).

Example 1:
Dialog Box
Specify Product: A
Document #: 123
Fruit: Oranges
# of Veggies: 1
Veggie Name: Green Beans
Insert "fruit" in D2 and "veggie" in D3
Insert formula (B x 10) in E2 and E3

Example 2:
Dialog Box
Specify Product: B
Document #: 234
Fruit: Bananas
# of Veggies: 2
Veggie #1: Asparagus
Veggie #2: Broccoli
Insert "fruit" in D4 and "veggie" in D5 - D6
Insert formula (B x 10) in E4, E5, and E6

I would like to band every other product entry light blue.