hello i need to combine multiple excel files(15) into one excel file. Each file has 2 sheets... R and S and data from both needs to consolidated into respective sheets. .. so i need a macro which can give one file with two sheets that consolidate data from all the files... All the files have same structure and columns.
Also please let me know step by step on how to run the macro and do i have to run it from the first file Thanks much.. this is urgent -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
