Posts by p4ankaz
-
-
I have a requirement where I have to search for a match taking composite column values defined in another worksheet.
Say I have worksheet named "sheet1"
[TABLE="class: outer_border, width: 500"]
[tr]
[td]Col A
[/td]
[td]Col B
[/td]
[td]Col C
[/td]
[td]Col D
[/td]
[td]Col E
[/td]
[/tr]
[tr]
[td]A
[/td]
[td][TABLE="width: 65"]
[tr]
[/tr][/td][tr]
[TD="width: 65"]New
[/tr]
[td]
[/TABLE]
[/TD]1
[/td]
[td][TABLE="width: 65"]
[tr]
[/tr][/td][tr]
[TD="width: 65"]W
[/tr]
[td][/td]
[/TABLE]
[/TD]
[/tr]
[tr]
[td][TABLE="width: 65"]
[tr]
[/tr][/td][tr]
[TD="width: 65"]B
[/tr]
[td]
[/TABLE]
[/TD]Old
[/td]
[td]2
[/td]
[td]X
[/td]
[td][/td]
[/tr]
[tr]
[td]C
[/td]
[td]New
[/td]
[td]3
[/td]
[td]Y
[/td]
[td][/td]
[/tr]
[tr]
[td]A
[/td]
[td]Old
[/td]
[td]6
[/td]
[td]P
[/td]
[td][/td]
[/tr]
[/TABLE]In "Sheet2" I have the composite mappings
[TABLE="width: 500"]
[tr]
[td]Col A
[/td]
[td]Col B
[/td]
[td]Replacement Value
[/td]
[/tr]
[tr]
[td]B
[/td]
[td]X
[/td]
[td]Value1
[/td]
[/tr]
[tr]
[td]A
[/td]
[td]P
[/td]
[td]value2
[/td]
[/tr]
[/TABLE]Result what I wanted to have is
[ATTACH=CONFIG]69828[/ATTACH]
Can some one help me out on this. I'm new to macro any just wondering is that possible or not ? Any feedback/ Suggestions would be very much appreciated !
Thanks for your time.
