Re: $$Excel-Macros$$ How to populate a browse window to select a file and capture the filename with full path?

ar to you. Thanks, Tony On Saturday, May 5, 2012 9:04:18 AM UTC-4, bé trần văn wrote: > > > > 2012/5/4 Tony Wu > >> Hello, >> >> I have a file needs to import data from another spreadsheet, that sheet >> will have different file name everyday, I want to

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

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:

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, >

Re: $$Excel-Macros$$ Need macro to verify part numbers between 2 sheets

please help? Thanks, Tony On Friday, May 4, 2012 10:20:48 AM UTC-4, Tony Wu wrote: > > It works, thanks a lot!!! > > > On Friday, May 4, 2012 10:02:25 AM UTC-4, Lalit_Mohan wrote: >> >> >> Hi >> >> PFA >> >> >> *Regards,* >> *L

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

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+ memb

Re: $$Excel-Macros$$ Need macro to verify part numbers between 2 sheets

It works, thanks a lot!!! On Friday, May 4, 2012 10:02:25 AM UTC-4, Lalit_Mohan wrote: > > > Hi > > PFA > > > *Regards,* > *Lalit Mohan* > *https://www.facebook.com/buzinesstransformation*<https://www.facebook.com/buzinesstransformation> > > >

$$Excel-Macros$$ How to populate a browse window to select a file and capture the filename with full path?

Hello, I have a file needs to import data from another spreadsheet, that sheet will have different file name everyday, I want to a macro to populate a window to open the file and use the full path of the file in further macro, example: ChDir "C:\Users\twu\Documents\Database\Item Master"

$$Excel-Macros$$ Need macro to verify part numbers between 2 sheets

Hello, I have 2 sheets in one file, one sheet "A" has less part numbers than the other sheet "B", would like to have a macro to verify the part number in "A" vs. "B", anything missing in "B" will be added to the bottom of sheet "A". My logical is trying to use "iserror(vlookup(...),0) to see i