Re: $$Excel-Macros$$ Macro required to add demand to substitution part and zero out the original one, see attachment.

2012-05-07 Thread Tony Wu
Sorry ... I didn;t see the Macro in the attachment. thanks, Tony On Saturday, May 5, 2012 9:23:46 AM UTC-4, Maries wrote: Hi, Check the attachment. Regards, MARIES. On Fri, May 4, 2012 at 12:27 PM, Tony Wu wumu...@gmail.com wrote: Hello, I have a file for the forecast demand,

Re: $$Excel-Macros$$ Macro required to add demand to substitution part and zero out the original one, see attachment.

2012-05-07 Thread Maries
Hi Tony, I have done by formula... Just check the sheets cells. There is no Macro codes inside. Regards, MARIES. On Mon, May 7, 2012 at 5:13 PM, Tony Wu wumu...@gmail.com wrote: Sorry ... I didn;t see the Macro in the attachment. thanks, Tony On Saturday, May 5, 2012 9:23:46 AM UTC-4,

Re: $$Excel-Macros$$ Macro required to add demand to substitution part and zero out the original one, see attachment.

2012-05-07 Thread Tony Wu
Hi Maries, I have checked the file but all numbers, no formula inside ... hence, the macro needs to do something on the data itself not to create another sheet. The sample I provided is to show what result I want to see not meaning it will be 2 sections of the data, I guess using formula will

$$Excel-Macros$$ Macro required to add demand to substitution part and zero out the original one, see attachment.

2012-05-04 Thread Tony Wu
Hello, I have a file for the forecast demand, some parts have substitution, what I need is if the part has substitution, the original demand will be added to the new part and original demand will be zero out, please see the attached file for reference. Thanks, Tony -- FORUM RULES (986+