My vba Transpose with condition, but its transposing the condition from other range

Hi,

I don't know if title of this tread is incorrect (i'm sorry)
let see if an expert help me a bit on this,i been trying to figure it out but i couldn't find a solution yet.
Okay, to make the short my story, I have a workbook with 2 sheets Sheet1 ('Records') and Sheet2 ('Output')
In sheet1 There are 4 pair Column that work in pair :
Col A and B should work together, Column C&D, E&F, and Col G&H are the Others.
Example of what i need to achieve on Col A & B
Col A2:A37 -> have some numbers,
Col B2:B37 -> from here i'm setting the condition, is like Points or (like Index)
So, the condition is : Any number from Column A2:A37 In "records" (Sheet1) have the same Condition ID (same Number ID) in Col B2:B37
Transpose it to "output" (sheet2).
But the detail is that the Condition ID or (Index) have to be transposed but just Once
e.i
Condition ID_
Col B2:B37__Numbers from Column A2:A37
____3 ___> 01 03 05
____2 ___> 07 09 11 13 15 17
____1 ___> 19 21 23 25 27 29 31 33 35 37 39 41 43 45
____0 ___> 47 49 51 53 55 57 59 61 63 65 67 69 71


This is my code, it's doing the job partially and on the wrong way.
It's taking The Numbers from Column C but with condition of Column A (It should be Numbers from A with Condition from B)

Please Login or Register  to view this content.

Thank you, any help is greatly appreciated !!

Please BUMP

Hi Franky alta.
look at these lines

Please Login or Register  to view this content.

Try this For Column "A & B" (Sheet Records) with results in (Sheet output)

Please Login or Register  to view this content.

Regards Mick

Hi nilem,

Unfortunately i don't have the code with me, but i'm sure that i try it the offset -1
and it display few different errors on my attempt, one of then was
"Run-time error ’13′: Type mismatch”, (tried other changes) i had "Compile error: variable not defined”
it might happened because i was already tired (4:30 this morning) until give up. LOL
I'll try on couples hours, Thank you very much, your suggestion opened my mind
i was close to fulfill my first code in VBA, yaaaaaaayyy!!

Thank you !

Hi MickG,


Thank you so much, i'm going to work with code as soon get home.


Thanks, appreciated