Macro to generate groups randomly of 20 numbers, being 10 of group A and 10 of group B,

Macro = to generate groups randomly of 20 numbers, being 10 of group A and 10 of group B, without polindromos,
Ok we have two groups = A and B, 45 numbers of each group, the 20 numbers generated
Can not have the couple reversed in the example group if it has 32 can not have 23 if it has 75 can not have 57. ... etc, within the group of 20 numbers 10 and 10 can not have the couple polindromo
Objective To generate more than 2000 (two thousand) lines of 20 interleaved numbers 10 to 10 groups A and B
Without the couple reversed.
Ex = 02 15 32.62 72 68 29 10 ..... 20 numbers
01 02 03 04 05 06 07 08 09 12 13 14 15 16 17 18 19 23 24 25 26 27 28 29 34 35 36 37 38 39 45 46 47 48 49 56 57 58 59 67 68 69 78 79 89 =group A
10 20 21 30 31 32 40 41 42 43 50 51 52 53 54 60 61 62 63 64 65 70 71 72 73 74 75 76 80 81 82 83 84 85 86 87 90 91 92 93 94 95 96 97 98= group B

Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.

Would for instance:
1 2 3 4 5 6 7 8 9 12
31 32 41 42 43 51 52 53 54 61
Be OK?

We advise you not to 'bump' (reply to) your own posts too quickly after posting, unless you are posting some sort of clarification. If you do bump, limit it to no more than once every day. Remember that your best helper may be asleep on the other side of the world.

This is DIFFERENT question and is only a bit related to original one.

It does not help users who use search tools to find solution for their problems if you change subject of the question within the thread.

So with a new question start a new thread. In this new thread, while posting attachment, please insert representative set of input data and representative output expected.

see https://www.excelforum.com/excel-pro...ml#post4784094