Splitting Set Of Worksheets in Excel into Multiple Workbooks [closed]
up vote
-1
down vote
favorite
I am looking for a VBA code that will help me split my master excel workbook into multiple worksheets for each department.
Essentially, the master sheet is designed like
Dept Summary | Sub Department 1 | ....... |Sub Department 10
and I want each department along with its sub departments to be one file. I have 10 departments total.
Any coders?
microsoft-excel vba macros
edited Nov 20 at 11:36
Ahmed Ashour
1,008610
asked Nov 20 at 10:56
vikdaas
1
closed as off-topic by PeterH, bertieb, fixer1234, Twisty Impersonator, Anaksunaman Nov 21 at 13:01
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This question is not about computer hardware or software, within the scope defined in the help center." – PeterH, bertieb, Twisty Impersonator
If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
up vote
-1
down vote
favorite
I am looking for a VBA code that will help me split my master excel workbook into multiple worksheets for each department.
Essentially, the master sheet is designed like
Dept Summary | Sub Department 1 | ....... |Sub Department 10
and I want each department along with its sub departments to be one file. I have 10 departments total.
Any coders?
microsoft-excel vba macros
edited Nov 20 at 11:36
Ahmed Ashour
1,008610
asked Nov 20 at 10:56
vikdaas
1
closed as off-topic by PeterH, bertieb, fixer1234, Twisty Impersonator, Anaksunaman Nov 21 at 13:01
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This question is not about computer hardware or software, within the scope defined in the help center." – PeterH, bertieb, Twisty Impersonator
If this question can be reworded to fit the rules in the help center, please edit the question.
Welcome to Super User. This isn't a "give me code" kind of site. Even if it was, there isn't enough detail here. However, if you tackle it yourself and run into a specific problem, that would likely be an on-topic, in-scope question. Just show your work and the details of the problem, and people here are likely to help.
– fixer1234
Nov 20 at 11:12
Ive tried codes that will split each tab into its eperate workbook but i cant figure out how to do it to apply to fix the collection of workbooks in its seperaste file.
– vikdaas
Nov 20 at 11:21
i have created a table that outlines what the pages shold be based on the tab names. but need to figure out how to link it to the vba script to reference and split based on the table
– vikdaas
Nov 20 at 11:21
1. Provide a visual of the workbook and the desired results (screenshots or mock-ups). 2.Show the code you're using. Describe what each module is supposed to do. 3. Describe what does and doesn't happen when you run it. Include any error messages. 4. Delete the last sentence; nobody is going to develop code for you. This isn't a free coding service. 5. People here will help you solve a specific, bite-sized problem, like figuring out why a specific thing you're doing isn't working.
– fixer1234
Nov 20 at 11:30
And please give addtional information by editing your question (not in comments)
– cybernetic.nomad
Nov 20 at 12:55
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I am looking for a VBA code that will help me split my master excel workbook into multiple worksheets for each department.
Essentially, the master sheet is designed like
Dept Summary | Sub Department 1 | ....... |Sub Department 10
and I want each department along with its sub departments to be one file. I have 10 departments total.
Any coders?
microsoft-excel vba macros
edited Nov 20 at 11:36
Ahmed Ashour
1,008610
asked Nov 20 at 10:56
vikdaas
1
I am looking for a VBA code that will help me split my master excel workbook into multiple worksheets for each department.
Essentially, the master sheet is designed like
Dept Summary | Sub Department 1 | ....... |Sub Department 10
and I want each department along with its sub departments to be one file. I have 10 departments total.
Any coders?
microsoft-excel vba macros
microsoft-excel vba macros
edited Nov 20 at 11:36
Ahmed Ashour
1,008610
asked Nov 20 at 10:56
vikdaas
1
edited Nov 20 at 11:36
Ahmed Ashour
1,008610
asked Nov 20 at 10:56
vikdaas
1
edited Nov 20 at 11:36
Ahmed Ashour
1,008610
edited Nov 20 at 11:36
Ahmed Ashour
1,008610
edited Nov 20 at 11:36
Ahmed Ashour
1,008610
1,008610
asked Nov 20 at 10:56
vikdaas
1
asked Nov 20 at 10:56
vikdaas
1
asked Nov 20 at 10:56
vikdaas
1
1
closed as off-topic by PeterH, bertieb, fixer1234, Twisty Impersonator, Anaksunaman Nov 21 at 13:01
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This question is not about computer hardware or software, within the scope defined in the help center." – PeterH, bertieb, Twisty Impersonator
If this question can be reworded to fit the rules in the help center, please edit the question.
closed as off-topic by PeterH, bertieb, fixer1234, Twisty Impersonator, Anaksunaman Nov 21 at 13:01
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This question is not about computer hardware or software, within the scope defined in the help center." – PeterH, bertieb, Twisty Impersonator
If this question can be reworded to fit the rules in the help center, please edit the question.
Welcome to Super User. This isn't a "give me code" kind of site. Even if it was, there isn't enough detail here. However, if you tackle it yourself and run into a specific problem, that would likely be an on-topic, in-scope question. Just show your work and the details of the problem, and people here are likely to help.
– fixer1234
Nov 20 at 11:12
Ive tried codes that will split each tab into its eperate workbook but i cant figure out how to do it to apply to fix the collection of workbooks in its seperaste file.
– vikdaas
Nov 20 at 11:21
i have created a table that outlines what the pages shold be based on the tab names. but need to figure out how to link it to the vba script to reference and split based on the table
– vikdaas
Nov 20 at 11:21
1. Provide a visual of the workbook and the desired results (screenshots or mock-ups). 2.Show the code you're using. Describe what each module is supposed to do. 3. Describe what does and doesn't happen when you run it. Include any error messages. 4. Delete the last sentence; nobody is going to develop code for you. This isn't a free coding service. 5. People here will help you solve a specific, bite-sized problem, like figuring out why a specific thing you're doing isn't working.
– fixer1234
Nov 20 at 11:30
And please give addtional information by editing your question (not in comments)
– cybernetic.nomad
Nov 20 at 12:55
add a comment |
Welcome to Super User. This isn't a "give me code" kind of site. Even if it was, there isn't enough detail here. However, if you tackle it yourself and run into a specific problem, that would likely be an on-topic, in-scope question. Just show your work and the details of the problem, and people here are likely to help.
– fixer1234
Nov 20 at 11:12
Ive tried codes that will split each tab into its eperate workbook but i cant figure out how to do it to apply to fix the collection of workbooks in its seperaste file.
– vikdaas
Nov 20 at 11:21
i have created a table that outlines what the pages shold be based on the tab names. but need to figure out how to link it to the vba script to reference and split based on the table
– vikdaas
Nov 20 at 11:21
1. Provide a visual of the workbook and the desired results (screenshots or mock-ups). 2.Show the code you're using. Describe what each module is supposed to do. 3. Describe what does and doesn't happen when you run it. Include any error messages. 4. Delete the last sentence; nobody is going to develop code for you. This isn't a free coding service. 5. People here will help you solve a specific, bite-sized problem, like figuring out why a specific thing you're doing isn't working.
– fixer1234
Nov 20 at 11:30
And please give addtional information by editing your question (not in comments)
– cybernetic.nomad
Nov 20 at 12:55
Welcome to Super User. This isn't a "give me code" kind of site. Even if it was, there isn't enough detail here. However, if you tackle it yourself and run into a specific problem, that would likely be an on-topic, in-scope question. Just show your work and the details of the problem, and people here are likely to help.
– fixer1234
Nov 20 at 11:12
Welcome to Super User. This isn't a "give me code" kind of site. Even if it was, there isn't enough detail here. However, if you tackle it yourself and run into a specific problem, that would likely be an on-topic, in-scope question. Just show your work and the details of the problem, and people here are likely to help.
– fixer1234
Nov 20 at 11:12
Ive tried codes that will split each tab into its eperate workbook but i cant figure out how to do it to apply to fix the collection of workbooks in its seperaste file.
– vikdaas
Nov 20 at 11:21
Ive tried codes that will split each tab into its eperate workbook but i cant figure out how to do it to apply to fix the collection of workbooks in its seperaste file.
– vikdaas
Nov 20 at 11:21
i have created a table that outlines what the pages shold be based on the tab names. but need to figure out how to link it to the vba script to reference and split based on the table
– vikdaas
Nov 20 at 11:21
i have created a table that outlines what the pages shold be based on the tab names. but need to figure out how to link it to the vba script to reference and split based on the table
– vikdaas
Nov 20 at 11:21
1. Provide a visual of the workbook and the desired results (screenshots or mock-ups). 2.Show the code you're using. Describe what each module is supposed to do. 3. Describe what does and doesn't happen when you run it. Include any error messages. 4. Delete the last sentence; nobody is going to develop code for you. This isn't a free coding service. 5. People here will help you solve a specific, bite-sized problem, like figuring out why a specific thing you're doing isn't working.
– fixer1234
Nov 20 at 11:30
1. Provide a visual of the workbook and the desired results (screenshots or mock-ups). 2.Show the code you're using. Describe what each module is supposed to do. 3. Describe what does and doesn't happen when you run it. Include any error messages. 4. Delete the last sentence; nobody is going to develop code for you. This isn't a free coding service. 5. People here will help you solve a specific, bite-sized problem, like figuring out why a specific thing you're doing isn't working.
– fixer1234
Nov 20 at 11:30
And please give addtional information by editing your question (not in comments)
– cybernetic.nomad
Nov 20 at 12:55
And please give addtional information by editing your question (not in comments)
– cybernetic.nomad
Nov 20 at 12:55
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Welcome to Super User. This isn't a "give me code" kind of site. Even if it was, there isn't enough detail here. However, if you tackle it yourself and run into a specific problem, that would likely be an on-topic, in-scope question. Just show your work and the details of the problem, and people here are likely to help.
– fixer1234
Nov 20 at 11:12
Ive tried codes that will split each tab into its eperate workbook but i cant figure out how to do it to apply to fix the collection of workbooks in its seperaste file.
– vikdaas
Nov 20 at 11:21
i have created a table that outlines what the pages shold be based on the tab names. but need to figure out how to link it to the vba script to reference and split based on the table
– vikdaas
Nov 20 at 11:21
1. Provide a visual of the workbook and the desired results (screenshots or mock-ups). 2.Show the code you're using. Describe what each module is supposed to do. 3. Describe what does and doesn't happen when you run it. Include any error messages. 4. Delete the last sentence; nobody is going to develop code for you. This isn't a free coding service. 5. People here will help you solve a specific, bite-sized problem, like figuring out why a specific thing you're doing isn't working.
– fixer1234
Nov 20 at 11:30
And please give addtional information by editing your question (not in comments)
– cybernetic.nomad
Nov 20 at 12:55