Merging Data from Multiple excel sheets to a Master sheet

[dilli34]

ICP_Amit Ranjan.xlsCP_Anup Gavankar.xlsAttachment 284511CP_Hitesh Chaurasia.xlsCP_Manas Mehta.xls

I am very new with VBA code (about 5 days old). I am using Excel 2003. This question is to help me in my job.

Question: Here i am having 20 time sheet entries of different team mates are in different excel sheets, and i have a master sheet, in that i need to copy data from every excel sheet Team mate name and project and no. of hours.

Please find attached excel sheets.

Please help me ,

[Pepe Le Mokko]

You can use this add-in.

There is also code for merging here

[dilli34]

Hi Pepe,

I am a mere beginner in these VB-Script concepts and I also have to submit the report within short time interval.
So it would be great if you provide me complete code section in detail with clear explanations.

Looking forward to your replying.

[Pepe Le Mokko]

Did you look at the add-in? It's well documented and easy to use. Even I succeeded in using it

[dilli34]

wht is the pwd for add-in?

[dilli34]

Error.png

it is throwing above error, how to solve?

help me