Re: $$Excel-Macros$$ Macro required to add demand to substitution part and zero out the original one, see attachment.
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 not make it. Can you help with? Thanks, Tony On Monday, May 7, 2012 3:16:06 PM UTC-4, Maries wrote: > > 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 wrote: > >> 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 wrote: >>> 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+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --**--** --** To post to this group, send email to excel-macros@googlegroups.com >>> >>> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> > > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Macro required to add demand to substitution part and zero out the original one, see attachment.
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 wrote: > 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 wrote: >> >>> 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+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> --**--** >>> --** >>> To post to this group, send email to excel-macros@googlegroups.com >>> >> >> -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Macro required to add demand to substitution part and zero out the original one, see attachment.
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 wrote: > >> 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+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> > > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Macro required to add demand to substitution part and zero out the original one, see attachment.
Hi, Check the attachment. Regards, MARIES. On Fri, May 4, 2012 at 12:27 PM, Tony Wu wrote: > 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+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com substituation sample.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet