Hello all VBA pros out there. I've never realised splitting a workbook up into multiple workbooks can be so difficult and I'm at my wits end.
Would actually like to find out if the below is actually humanely possible.
What I'm trying to do:
- Split a workbook with multiple tabs up based on the criteria that cell B1 is the same
- Note that B1 is NOT the same value in all sheets and I would like a macro to be generated based on all the variables. For example, B1 = A in one new workbook (contains multiple sheets with B1 = A on original workbook. Then B1 = B in another new workbook (once again contains multiple sheets with B1 = B) and so on and so forth.
How I'm trying to go about it
- Write a VBA code that selects all sheets that B1 = A
- Move these selected worksheets to a new workbook and make sure that it's "paste values". Original file unaffected.
- Rinse and Repeat for B1 = B, B1 = C etc.
Any simpler ideas is definitely welcome as well.
I've had done some research and found 2 codes that might be useful, however it doesn't do exactly what I require.
[URL unfurl="true"]https://www.tek-tips.com/viewthread.cfm?qid=849130[/url]
[URL unfurl="true"]https://stackoverflow.com/questions/43763372/edit-vba-to-paste-multiple-sheets-as-values-into-new-workbook[/url]
Thanks very much in advance.
Would actually like to find out if the below is actually humanely possible.
What I'm trying to do:
- Split a workbook with multiple tabs up based on the criteria that cell B1 is the same
- Note that B1 is NOT the same value in all sheets and I would like a macro to be generated based on all the variables. For example, B1 = A in one new workbook (contains multiple sheets with B1 = A on original workbook. Then B1 = B in another new workbook (once again contains multiple sheets with B1 = B) and so on and so forth.
How I'm trying to go about it
- Write a VBA code that selects all sheets that B1 = A
- Move these selected worksheets to a new workbook and make sure that it's "paste values". Original file unaffected.
- Rinse and Repeat for B1 = B, B1 = C etc.
Any simpler ideas is definitely welcome as well.
I've had done some research and found 2 codes that might be useful, however it doesn't do exactly what I require.
[URL unfurl="true"]https://www.tek-tips.com/viewthread.cfm?qid=849130[/url]
[URL unfurl="true"]https://stackoverflow.com/questions/43763372/edit-vba-to-paste-multiple-sheets-as-values-into-new-workbook[/url]
Thanks very much in advance.