get cell value accordingly

[yjmmay34]

I am writing a macro to automatically get values from one workbook to another new workbook based on the according Week and Month. i only attached week13 's data. but i will have week14,week15 and so on. which means there will be several spreadsheets and i have to write macro in the workbook(" WaterfallChart") to antomatically get those values to according cells. can anyone please help me with this part ? Thanks a lot.

[excelxx]

Hi yjmmay34

Please find attached an amended Waterfallchart file. The macro works on the assumption that the weekly files would be in the exact same format as the sample file provided.

Please let me know if you have any problems with the file.

Regards

[yjmmay34]

Thank you very much. I thought the code could run the different format file, but if not, i will save the file in the format as below i attached . there are only two example report, i still have more reports like this which in different week and month. Could you please show the code to run the macro automatically under this situation?? Thank you so much!

[excelxx]

Hi yjmmay34,

Sorry for the delay in getting back to you.

I have revised the file, to be executed on the new format you sent me.

Also you have the option to select a number of files at the same time and the code will update either layout based on the active sheet you are in when you execute the code.

Please let me know if you have any problems.

Regards

[yjmmay34]

Hi, excelxx. Thank you for helping me with the code. But i i have another problem. i have the "Event Date Year" and "Event Date Month" here which is something like customer forcast. And in column "I" there is "Month Refresh". what i want is that any current year(2010) month is past compare with the "Month Refresh", the Quantiti Sum should be deleted. I wrote code like this, but cannot work. Please help me modify it if there is any mistakes. there is attachmentbelow and the format is fixed. only the Month Refresh and Quantity Sum will be changed. Greatly appreciated!

Please Login or Register  to view this content.