Re: $$Excel-Macros$$ Fwd: Merge files with few criteria of pasting

2014-09-30 Thread Vaibhav Joshi
Check this file.. How to use? Put your all files which you want to import under one folder.. Open this file & click on button to run macro... Macro will open files one by one...chk for inventory sheet copy & paste data in inventory sheet of this file & so as with sheet name others...rest all sh

Re: $$Excel-Macros$$ Fwd: Merge files with few criteria of pasting

2014-09-30 Thread Vaibhav Joshi
also what should be Update Date, Date of Consolidation? + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 2:30 PM, Vaibhav Joshi wrote: > you didnt gave format of Inventory worksheet in Output > > + > *I did not do this for you. God is here w

Re: $$Excel-Macros$$ Fwd: Merge files with few criteria of pasting

2014-09-30 Thread Vaibhav Joshi
you didnt gave format of Inventory worksheet in Output + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 3:32 AM, Vinod Narayanan wrote: > Hi Gurus, > > > > Need your help!. I need to consolidate many files received from various > branches from

$$Excel-Macros$$ Fwd: Merge files with few criteria of pasting

2014-09-29 Thread Vinod Narayanan
Hi Gurus, Need your help!. I need to consolidate many files received from various branches from time to time basis. Attached is the sample file wherein I have added 2 worksheets. One is the input file received from Branches and another the Output file. *Input file:* As there files are save