matching and pasting adjuscent values in 2 sheets

[kshitij_dch]

hii all

2 excel workbooks one Is wb1 and other is wb2, wb1 has 4 columns , column "A" has date , "B" has ID'S ," C" has names , "D" has Duration
Wb 2 has 4 columns . Column "C" contain Date , "D" contains names , "E" contain ID"S , "I" contain Time Duration .

macro to look into wb1 column "A" filter dates wise like 1 , 2 , 3.... filter suppose 5/2/2012(mm.dd.yy), go in Wb2 and check according to date sheets are made , if date is "filtered date" in Wb1 than macro will go in Wb2 , sheet 2,


the ID"S of "B" column of wb1 sheet1 , pick values and id's as well adjucent those id's in column "F" , go in wb2 sheet 2 match these ID'S with the ID'd in column "E" , in front of those ID'S paste those picked values adjucent in column J of wb2 sheet 2


please help its important for me

 

[pplstuff]

You could do this with formulas. Although, if your data is more than 100k records, it might have a slow calc time. Would you prefer a macro?

 

[kshitij_dch]

yes i need a macro please