copying from multiple workbooks and paste in a single sheet

[venkat356]

HI,

i need to copy the data from multiple sheets and need to be pasted in a single sheet..

my requirement is as follows:

i have five workbooks.first one is Details.xls(Master)

second is week1.xls and the rest are week2.xls,week3.xls,week4.xls.All these work books have sheets namely jan feb and march etc.and each sheet contains certain data.first row is name with number

example kumar115,venkat125 etc......

now i need to copy the data from weeks to master details.xls

example:from week1.xls and from the sheet jan need to copy few columns referenced by the name in the first row into the details .xls in jan sheet.similarly from other three workbooks data need to be copied....

Please help me for writing a macro


Regards

 

[erik.van.geit]

Hi,

this should get you started
http://www.mrexcel.com/board2/viewtopic.php?t=145246

kind regards,
Erik