Many to Many Relationship VBA Code

[Sadi915]

I have a set of data in Input sheet. It should be mapped through many-many relationship logic.

Input Sheet:

IP(Header)	FP(Header)	QP(Header)
CH	YT	1​
JA	TR	2​

Output sheet:

IP(Header)	FP(Header)	QP(Header)
CH	YT	1​
CH	YT	2​
CH	TR	1​
CH	TR	2​
JA	YT	1​
JA	YT	2​
JA	TR	1​
JA	TR	2​

Please download mini workbook for better understanding. Your thoughts are highly appreciated.

Many to Many Relationship VBA.xlsm
	A	B	C
1	IP(Header)	FP(Header)	QP(Header)
2	CH	YT	1
3	JA	TR	2
Input Sheet

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Many to Many mapping relationship Using VBA - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[diddi]

and what is your question?