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