Need help generating list

[jaydapolarbear]

I need to generate a list of six digit numbers 0-9. No number is repeating and each six digit number has a 7, 1, 0, and 3 included in no particular order. Please help with step by step instructions. Thank you!

[pjwhitfield]

when you say "no number is repeating" do you mean in your list or within the 6 digits? ie can you have 710375?

[FDibbins]

I am not able to help with this, but onteh face of it, pj, I would have to say - no you cant have that because 7 is repeated

[jaydapolarbear]

Thanks for responding PJ! No numbers repeating at all within the six digits.

[shg]

Put this in a standard module, do Alt+F8, and run macro JDPB. Results appear in A1:A10800.

Please Login or Register  to view this content.

[jaydapolarbear]

Hi shg....You are wonderful!!! Only problem is....I am a computer illiterate woman. I am sorry to ask you this and if you wouldn't mind?.....can you explain in dummy terms how to get Standard Module and so on? I appreciate your help ( :

[shg]

Do Alt+F11 to open the visual basic editor. Insert > Module, paste the code in the window that opens.

Alt+Q to return to Excel.

The resulting workbook must be saved as an xlsm file to preserve the code.

[shg]

... or see the attached workbook.

[jaydapolarbear]

Thank you sooooo much shg!!! I am your #1 fan! You are selfless and kind. I am very grateful

[shg]

You're welcome.