Compare different excel sheets

Closed
sriram - Mar 19, 2015 at 07:38 AM
hi i need a macro in excel for my problem

in sheet 1 i have
M1 M2
cola col b col i col j
10 a 10 a
20 b - -
30 c 20 e
40 d 30 d

and so on

i want this sheet 1 as ref and FOR M1 i have in sheet 2
cola col b col c
10 a x
20 b y
30 c z
40 d aa

i want this sheet 1 as ref and FOR M1 i have in sheet 3
cola col b col c
10 a ab
20 b ac
30 c ad
40 d ae

same for M2 in sheet4 & sheet5

in sheet4
cola col b col c
10 a x
- - -
20 e z
30 d aa

in sheet5
cola col b col c
10 a ab
- - -
20 e af
30 d -

I want i n sheet 6

cola col b colc col k col l col m
10 a x,ab 10 a x,ab
20 b y,ac - - -
30 c z,ad 20 e z,af
40 d aa,ae 30 d aa,-

can any one help me in developing this macro ("-" means balnk cell)