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 <v...@vabs.in> wrote: > 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 <nvino...@gmail.com> > wrote: > >> 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 saved thru a secured server, the filenames are auto >> generated and the branch name is mentioned in Cell B2 only(Due to some >> reason, B2 and C2 are merged) >> >> It will has many worksheets within it. But I’m need to consolidate >> worksheet ‘Inventory’ and ‘Others’ with to their respective worksheets in >> the output consolidated file. >> >> >> >> *Output file (Consolidated file):* >> >> >> >> As I mentioned above, information from “Inventory” should be saved in >> Inventory worksheet in Output file and ‘Others’ worksheet in ‘Others’ in >> Output file. >> >> >> >> Some complications: >> >> · Name of the Branch (Cell B2) need to be saved in each row >> whether the respective branch detail are pasted in Output file Col D. >> >> · Input file – Col A to C need to be pasted in Output file - >> Col E to G >> >> · Input file – Col E to M need to be pasted in Output file - >> Col H to P >> >> >> >> >> >> Hope I was able to provide the required information for creating a macro. >> >> >> >> Regards >> >> Vinod >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 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) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
