import data by finding and matching using Visual basis...

Dear friends,


I want to arange a Large Data using vba.please help me in this....

I have saved a excelfile in (D:\Bhavcopy.)the files are saved in Date wise. in every file I have a few script name and their Open,High,Low,Close,volume.


example file are mention bellow attachment....I also attached a one main destination sheet(dashboard) where I want to estract data...

WHAT I WANT:.

=INDEX([cm01NOV2012.xlsx]cm01NOV2012bhav!C2:C1575,MATCH([cm01NOV2012.xlsx]Sheet1!A6&[cm01NOV2012.xlsx]Sheet1!A1,[cm01NOV2012.xlsx]cm01NOV2012bhav!K2:K1575&[cm01NOV2012.xlsx]cm01NOV2012bhav!A2:A1575,0))

similer like above formula but want to program in VBA language.in detail mention below........


in dashboard sheet A1 is a "Script name(for example RELIANCE)" and A3 to 500 are "Date".( for example "A6" ="01-nov-2012".).
I want to create a macro which Find with matching a Script name (A1) and Date(a3 to a500)and put data in " a" Open rate in "b" collomn" high rate in" c collomn, low rate in "d coloumn, close rate in e collomn and volume in F collomn..

i also want to create a multiple page script wise.. in dashboard sheet

example are puts on attachment..

please do the needful .. it is urgent......

really feeling thanks in Advance...

please find the attachment....