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