create a field where you type or select 10 numbers.

[jorel]

create a field where you type or select 10 numbers, which will be replaced by the three corresponding matrices,
* objective = select 10 numbers that will be exchanged in their positions, equivalent in the positions of the three matrices

[spencer_time]

I don't understand, and can't picture, what it is that you want to do.

Can you give a spreadsheet with a before and after on separate sheets?

[jorel]

hello=
https://www.excelforum.com/attachmen...1&d=1569934177

[jorel]

Hello, I will choose 10 numbers
* from the limit of 01 to 25 the macro
* shall replace or replace with the numbers of the three
* matrices in their positions,
The goal is to combine in sequences with 10 selected numbers

[spencer_time]

I'm sorry I'm still not understanding.

This may be something that I do not understand from a technical aspect. Or it may be a language barrier, I'm really not sure at this point.

[jorel]

ok let's go step by step
* we have three matrices from 01 to 10
matrix with doubles, cracks and quadruples
but the 10 numbers I will select or type
* in my choice. the macro has to do the replacement
* ex =
* I chose ten numbers from 01 to 25
02 08 10 15 16 17 20 21 24 25
* replace in the matrices
01 02 then 02 08
01 07 10 = is equal to 02 20 25
* you have to look at the positions from 01 to 10
* and exchange for the 10 numbers chosen from 01 to 25

[jorel]

hello please