split workbook

I have a workbook that has 14 worksheets. I'm looking for some code that will split these worksheets out into individual workbooks while retaining formatting. I did find some code that does essentially what I am looking for: Sub Splitbook() 'Updateby20140612 Dim xPath As String xPath =...

Hi....I found this code on the forum to split workbook into separate worksheets which works perfectly but I only want to copy across certain columns to the new worksheets. I want columns I, M and W to copy across the new tabs. Can someone please assist. This Sub columntosheets() Const...

Good evening to all, It is very nice to meet you! I would like your help for a vba code to do the following: I have a workbook containing sheets A, B, C. All sheets have the column "Name" as their first column (there might be multiple lines with the same name). I would like to split the files...

So I have one workbook with about 50 worksheets (tabs). Is there a way to split each tab and save as their own workbook? Here's the quirk, the master workbook has one (lookup table) sheet that has to be copied with each of those other sheets. Master Workbook (1 lookup tab + 49 tabs) [lookup...

Hi all, I am a true newbie on VBA and I would very much appreciate help on the below issue: I have an initial workbook “Tehnicieni” with 3 sheets as follows: SheetA – containing formulas and charts based on the table from SheetC; SheetB – containing formulas and charts based on the table...

Hi guys, I have some successful code which takes my active workbook, splits and saves out the sheets. I would like to now have this code run on a whole folder of excel files in a folder, not the activeworkbook. Can anyone help me modify it to do this (don't mind if you have to specify the...

Hi Everyone, Just looking for some code to help me delete tabs after a workbook split. Basically, I have a macro that splits a worksheets (not workbooks) by a unique identifier found in column A. I would like all tabs except the relevant one to be deleted from the new file, and there are too...

Hi, I'm trying to split a workbook by the values in two different columns. I have a workbook that has letters in column J (A-R) and numbers in column K (1-10). I can succesfully use the code here: http://www.mrexcel.com/forum/showthread.php?352057-Split-Worksheet-to-Multiple-Worksheets to...

Hi Guys, I want to know is the following possible please? I have say 50 cost centre: 10,20,30,40,50,60……. One per worksheet Then a worksheet of what mangers gets what: each cost centre in a different cell Paul: 10,40,50 Jim: 20,30,40 Mary: 40,60 Based on those cells I want to group the...