Cells Iteration

[Mut]

Dear all,

I have DATA 1 and DATA 2
And, I have to iterate every DATA 1 to every DATA 2
For example:
DATA 1 | DATA 2
J | J
F | J
S | F

RESULT
J | J
J | J
J | F
F | J
F | J
F | F
S | J
S | J
S | F

I attached the file for clear example
Could it be automatically by macros?
Any help would be appreciated

Thanks,
Mut

[jeffreybrown]

Courtesy of martindwilson...I saw him do this today...

In I1 =INDEX($A$2:$A$12,MATCH(J2&K2,INDEX($B$2:$B$12&$C$2:$C$12,0),0))
In L1 =INDEX($E$2:$E$12,MATCH(M2&N2,INDEX($F$2:$F$12&$G$2:$G$12,0),0))

[Mut]

But the formula need values in coloumn J&K or M&N. How MATCH will work if we don't know those values of iteration before.
What I need is the iteration from range A2:C12 with E2:G7..

Thanks,
MT

[JBeaucaire]

The VBA approach to this problem:

Please Login or Register  to view this content.

(sheet attached)

[JBeaucaire]

I see where you Set CpyRNG and would like to know how I can see the entire range as it is held in memory.

As I step through the code using F8 I know I can open up the Locals window and view the values of the variable plus many other things, but how can I see the CpyRNG?

Jeffrey, please continue the thread discussion in the open forum, as per the Forum Rules. (See rule #4) Thanks.

To simply see the address is easy:

Please Login or Register  to view this content.

...will print the range in the Immediate Window (CTRL-G to see it if it's not open already).


You need to see individual values within the CpyRNG? Any particular reason why? That starts to get a bit ugly to read code-wise, and I don't do that very often. If the values inside the CpyRNG are relevant to the copy procedure in some way, I would probably rethink the whole thing, so more info makes it easier to understand what you're thinking.

[jeffreybrown]

No I don't need to see anything in particular outside of the address for Set CpyRNG.

I keep forgetting about Debug.Print and that answers the question.

Thanks for helping again...

[JBeaucaire]

Edited down.

[Mut]

Woww.. it works!!
Thanks for your help...

Regards,
Mut

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.