to compare between two workbooks and retrieve data..if match is found

jumbo

New member
Joined
Apr 20, 2014
Messages
1
Reaction score
0
Points
0
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.






workbook1_sheet1.jpgworkbook1_sheet2.jpgworkbook2.jpg
 
Top