Pls help add comments to this code

[yjmmay34]

Hello, i need to understand this code step by step, but i am a VBA beginner. So need someone to help to write down the comments detaily for me . Greatly appreciated!

Please Login or Register  to view this content.

[davesexcel]

It would help if you supplied a workbook that went with the code, please don't expect somebody to design a workbook that works with your code, and then have to figure out how it works.

What is the code supposed to do?

[royUK]

Most of the variables aren't declared either

[yjmmay34]

It would help if you supplied a workbook that went with the code, please don't expect somebody to design a workbook that works with your code, and then have to figure out how it works.

What is the code supposed to do?

hi,
it's like pull data from several workbooks (for example report 1 and 2) and accumulate those data in only one new workbook (MyProgram.xls) . those sheets in MyProgram file should be separated by the customer name and Geometry, and the data(Quantity sum) have to be fill in the correct sheet and go into the cell acooding to the week and Month.
Thanks a lot.
Report1.XLS

Report2.XLS

MyProgram.xls.xlsx

[yjmmay34]

Most of the variables aren't declared either

hi, royUK. i have a question here. Can month compare to month like Jan < Mar, then delete the value of the Jan and just leave it blank??? because i only know that numbers can compare to each other, then how about the month in word form,is it possible?