Product Configurator Using dynamic Option buttons.

Hi All,

I'm new to this group and felt exited by going thru various posts. I hope someone could help me with the problem that i'm trying to resolve.
I'm currently designing an excel based product configurator. I've completed most of it by linking the back end data and now what i'm really looking for is programatically assigning Option buttons for the items under a group so that the end user can select one of the options available under each group.
please refer to the table below as an example.

Col-A............Col-B............... Col-C ..............................Col-D........... Col-E
Group..........Item.................Option Button............T / F(selection)........Price
-------------------------------------------------------------------------------------------------------------------
Fruits.............Apple........... Option Button-Y.........True...........Look up based on Col D
......................Orange.........Option Button-N.........False
......................Grapes.........Option Button-N.........False
Vegetables....Carrot
......................LadiesFinger
......................Potatoes
Beverages.....Pepsi
......................CocaCola................................................Grand Tot of Price based on selection.
---------------------------------------------------------------------------------------------------------------------
I got this working by creating Active X option buttons from the control tool box manually. However, the issue is for different products the number of Group's and Items under them may vary. Hence, need for a dynamic logic that can loop thru the data and create Groups and option buttons based on number of cells populated.
I can re-arrange the data as suggested if that reduces the coding complexity. I'm fairly new to coding so any help with a VBA code that could bring out the desired results would be highly appreciated. Many Thanks !