generating 6 number lotto combinations

I know I am going to get flamed for this post and told "Use the SEARCH button"......I have but can't find what I am looking for OR have ran across it maybe and I just dont understand what I have read. I dont know what a macro or vba is or how to use it, and barely know how to use excel, except for "simple" entering stuff in different cells.

what I am wanting (trying) to do is:

Generate all 6 number combinations ( a little over 25 million) in a 6/54 lotto.
ie. just need one version of combination like: ex. 2-22-30-33-45-51 .... not 22-33-2-30-51-45 as these are the 'same' numbers in a different order and I dont need that.

in the next colom next to every combination have the sum of those combinations. I'm looking mainly for combinations with sum to be between 127-203

I hope I have explained well enough what I am after. If anyone can help me and how to apply this It would be very greatly appreciated. Sorry if the answer was in the search and I am just not sharp enough to have understood it, because I did search in this one and more forums too. (again.....very very novice-beginner at excel).

Thanks,
Brent

Originally Posted by shg

Generating them is easy.

Aside from the fact that you'd have a 100MB file, what would you do if you had them?

The size of the file is big, but ok.....use it to make a plan of what I want to play

Thanks shg....I go to tools, macros, create and paste this code in and click run... it keeps giving me 'Run-time error '1004' Application=defined or Object-defined error

If i click the debug, it highlights in yellow
Cells(iRow, iCol) = s5 & Format(i6, "00")

it generates about 65000

thank you,
Brent