hi Gurus,

im new macros...im stuck with a concept.. dont know how to procees further.

I have a work with for ex 30*5 matrix with data. i need to group these data in sheet2 with condition if data in column D occurs greater then or equal to 5. with space of two colums left after every grouping. Rest/lesser then can be ignore.

After grouping, i need to check whether there is a match between column c,d in (sheet2)workbook1 with coulmn a,b in workbook2.

if it matches i need to copy contents from coulmn B,C,D from workbook2 and paste into column E,F,G in sheet2/workbook1.

Click image for larger version. 

Name:	workbook1_sheet1.jpg 
Views:	11 
Size:	91.6 KB 
ID:	2255Click image for larger version. 

Name:	workbook1_sheet2.jpg 
Views:	5 
Size:	99.6 KB 
ID:	2256Click image for larger version. 

Name:	workbook2.jpg 
Views:	4 
Size:	64.4 KB 
ID:	2257