"Dinamic array rearange from row to columns"

[daboho]

Clip1.jpg
i want Data in column b after 3 row copy to kol E,F,G,H,I

Please Login or Register  to view this content.

[karedog]

Maybe :

Please Login or Register  to view this content.

[daboho]

You is the best my teacher sir karedog
One again i want change to function this makro where is wrong thank before to my teacher

Please Login or Register  to view this content.

[/QUOTE]

[karedog]

You are welcome.
The function on post #3 is good, maybe you don't place it correctly.
First select range E3:I5, press F2 on keyboard, and type this formula :

Please Login or Register  to view this content.

and then press and hold (without releasing) Ctrl Shift Enter on keyboard (because this is an array formula, so not just Enter key).
The result must be shown correctly.

[daboho]

Sir karedog
Is possible from my pic
If b3= 3 then result array in col d3:d5=c3+c3+c3 become in d3= a, d4,a,d5=a
And loop after kol b <> "",if in b4=2 and c4=b then in d6:d7 = b,b with array how can do it

[karedog]

Sir daboho,
I hope this is what you are looking for :

Please Login or Register  to view this content.

[daboho]

Hehe you is briliant
Sir karedog i want ask
1.What different a() with a this is same variant
2.is array still can know adress row
Example in each in range (a1:a10).value = 1 then with array i store value to array
For i = 1 to ubound(a,1)
If a(i,1) = "1" then r=r+1:y(r,1)=a(i,1)
Next my asking how to do with array to hide row
Maybe can do like union range (loop range)
Maybe can do...range(y).entirerow. hidden... It is posible use array