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...
Bookmarks