Make unique combinations of 1 column with 1 contraint. VBA

Hi Excel geniuses

I need help with generating unique combinations of digit values in column "A":

A ("Input")
0.660
0.742
0.825
0.990
1.155
1.237
1.253

I have attached my workbook. I have used a vba code from a teaching webside, which worked out ok.
The result is marked with light red in my workbook.

However, I have encountered 3 problems:
1. The combinations are stored together in one single cell. Once outputted, I would like them separated in different columns, so I can make a sum total of the combinations. The Blue table is my end goal.
2. The VBA code does not allow each input from the yellow column ("A") to be used more than once. I need each width to be able being used more than once.
3. I would like a constraint inside the VBA code, so only combinations with sum total less than (=<) 3.85 are generated. Is this possible?

I made The Blue table manually to illustrate my end goal. I hope the task makes sense.

1664998082208.png

Hi TSM

Thanks for your reply.

Yes that is a good alternative option. However, I am really hoping for VBA solution that can also solve my second problem

Make sense, thanks! I put it in as a Worksheet.function with VBA.

On the other hand, can you be of any help with the second or third problem? How can i get combinations with each input included several times? for instance: 0.742 - 0.742 - 0.825 - 0.825

Hi Ali

Yes, please accept my apologies. I was informed about this issue in a pop-up window on the site and I made an attempt to edit my post and include the link. I must not have saved my post probably or something. Again, thank you for the clarification.

Any help would be appreciated.