hi Gurus,

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



I have a workbook 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. Rest/lesser then can be ignore..
NOTE : with space of two columns left after every grouping.



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.

i have attached a sample workbook...

https://app.box.com/s/1q2kv9mhd8mmiagj0gb7
https://app.box.com/s/8huhjpcwe1xwpe0vwlms

Thanks in advance...