Extract data from rng

[andrichara]

hI guys!,i have at A1:A36 a random generator of 1-36 numbers.i need to extract the results every time of change at B1:B36, then after the next change(every spin) the new results to be extracted at C1:36 and so on.is there any formula for that?thank you so much!

 

[andrichara]

can anybody have an option?

 

[DataBlake]

you should post your code so people understand what it is that your code is doing.
as well as any examples/ data you can provide.
without looking at your code try this

Sub eXtractt()
'add this to your declarations
Dim cCounter As Long



'replace your range with
With ActiveSheet
cCounter = .Cells(1, Columns.Count).End(xlToLeft).Column
.Range(Cells(1, cCounter + 1), Cells(36, cCounter + 1)) = 'WHATEVER YOUR CODE IS FOR RNG
End With

End Sub

again....can't be sure this is what you need with so little info

 

[DataBlake]

or to loop through each cell if your RNG isnt ranged based

Sub eXtractt()
'add this to your declarations
Dim cCounter As Long
Dim i As Long



'replace your range with
With ActiveSheet

cCounter = .Cells(1, Columns.Count).End(xlToLeft).Column
For i = 1 To 36
.Cells(i, cCounter + 1) = 'WHATEVER YOUR CODE IS FOR RNG
next i
End With

End Sub

 

[andrichara]

=IFERROR(MODE(IF(COUNTIF($AH$15:AH32,$AO$4:$BF$12)=0,IF($AO$4:$BF$12>0,$AO$4:$BF$12))),"") ,i use tis formula at Ah15 to extract values from a box AO4:BF12,the values of the box are changing at every new spin at A1:A50 and also the values of the array formula above,What i need is to copy that formula at the next columns and get the valus at every spin without changing.So at AH15:AH32 once apeared to dont change ,the same at next columns every new spin ,the numbers stay!! i hope You can do it!

 

[DataBlake]

the values of the box are changing at every new spin at A1:A50

what is a "new spin"?
is there code for this spin?

sounds like you're trying to do this
press a button, numbers are generated a1 - a50, press the button again and those values are shifted to the right and a new set of numbers are generated from a1 - a50?
the problem here is i don't know the method you're using for "spinning" so i can't give you code that will work with your "spin"

please be as clear as possible and include any and all code that is relevant