First of all, take a look at the Forum "rules".some of them are just simple good ideas, like: 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. The fact is: EVERYONE that posts a question to the group is looking for assistance.Everyone here has their own area of expertise, or at least experience.If your question is regarding Pivot Tables, you'd like someone that has experience in Pivot tables to answer your question!I get 30-80 emails each day.When I have a few minutes available, I look through them to see which ones I can answer in the time I have available.BASED ON THE THREAD TITLE. Normally, I ignore any that say "Help Required", or "Urgent" because if I have 20 minutes to spend, I don't want to spend 18 of it trying to figure out what is needed... In this case, I had cleared my in-box earlier in the day and since I had 20 minutes while some data was formatted, I decided to take a look at a post that others had ignored. So... to your question: I wrote a macro that clears all sheets except the one called "Master" and then copies the data into new sheets (creating them as required). hope this points you in the right direction.
Paul----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- On Thursday, January 12, 2017 3:43 AM, sriram ji <sriramg...@gmail.com> wrote: Hi Excel Guru, Kindly help me the below attached file, Thanks in advance. Thanks & Regards,Sriram G -- 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 https://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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Copy_to_Sheets.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12