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.
Merge files.xlsx
Description: MS-Excel 2007 spreadsheet
