提示:其它语言是由 Google 机器翻译的。 你可以访问 English 版本。
登录
x
or
x
x
马上登记
x

or

如何拆分工作簿以在Excel中分隔Excel文件?

您可能需要拆分大型工作簿来分隔Excel文件,并将工作簿的每个工作表保存为单独的Excel文件。 例如,您可以将工作簿拆分为多个单独的Excel文件,然后将每个文件分发给不同的人员进行处理。 通过这样做,您可以让某些人处理特定的数据,并保证您的数据安全。 本文将介绍如何拆分大型工作簿以基于每个工作表分开Excel文件。

  1. 通过复制和粘贴拆分工作簿以分离Excel文件
  2. 拆分工作簿以使用“移动”或“复制”功能分隔Excel文件
  3. 将工作簿拆分为使用VBA代码分隔Excel文件
  4. 使用Kutools for Excel轻松拆分工作簿以分离Excel / PDF / CSV / TXT文件

快速拆分工作簿以在Excel中分离Excel / PDF / TXT / CSV文件

通常我们可以将工作簿拆分为单独的Excel文件 移动或复制 Excel中的功能。 但是Kutools for Excel的 分割工作簿 实用程序可以帮助您轻松拆分工作簿并将每个工作表另存为Excel中的单独PDF / TEXT / CSV文件或工作簿。 全功能免费试用30天!
广告拆分工作簿excel

Kutools for Excel -包括多个用于Excel的300便捷工具。 全功能免费试用30天,无需信用卡! 现在加入

Office选项卡在Office中启用选项卡式编辑和浏览,使您的工作更轻松......
Kutools for Excel解决了您的大多数问题,并使您的生产率提高了80%
  • 重用任何东西: 将最常用或最复杂的公式,图表和其他任何内容添加到您的收藏夹中,并在将来快速重复使用它们。
  • 超过20文本功能: 从文本字符串中提取数字; 提取或删除部分文本; 将数字和货币转换为英语单词...
  • 合并工具:多个工作簿和表格合二为一; 合并多个单元格/行/列而不丢失数据; 合并重复行和总和...
  • 拆分工具:根据价值将数据拆分为多个表格; 一个工作簿到多个Excel,PDF或CSV文件; 一列到多列......
  • 粘贴跳过 隐藏/过滤行; 数和总和 按背景颜色; 创建邮件列表和 通过Cell的价值发送电子邮件...
  • 超级过滤器: 创建高级过滤方案并应用于任何工作表; 排序 按周,日,频率等; 筛选 通过大胆,公式,评论......
  • 超过300强大的功能; 与Office 2007-2019和365一起使用; 支持所有语言; 在您的企业或组织中轻松部署。

通过复制和粘贴拆分工作簿以分离Excel文件


在平时,使用 复制 指挥 命令可以手动将工作簿另存为单独的Excel文件。 首先,选择要保存为单独文件的整个工作表,创建一个新工作簿,然后将其粘贴到新工作簿中,最后保存它。

如果您只需要将几个工作表拆分为单独的文件,这是一种易于使用的方法。 但是,通过手动复制和粘贴来拆分许多工作表一定是耗时且繁琐的。


拆分工作簿以使用“移动”或“复制”功能分隔Excel文件

此方法将引入“移动”或“复制”功能,以将选定的工作表移动或复制到新工作簿,并另存为单独的工作簿。 请做如下:

1。 在“工作表”选项卡栏中选择工作表,右键单击,然后选择 移动或复制 从上下文菜单。 看截图:

注意:举行 按Ctrl 键,您可以选择多个不相邻的工作表,并在工作表标签栏中逐个单击它们; 保持 转移 键,您可以通过单击工作表标签栏中的第一个和最后一个选择多个相邻的工作表。

2。 在“移动或复制”对话框中,选择 (新书) 来自 预订 下拉列表中,检查 创建一个副本 选项,然后单击 OK 按钮。 看截图:

3。 现在,所有选定的工作表都将复制到新工作簿。 点击 文件 > 保存 保存新的工作簿。


将工作簿拆分为使用VBA代码分隔Excel文件

以下VBA代码可以帮助您快速拆分当前工作簿的多个工作表以分离Excel文件,请按照以下步骤操作:

1。 为要分割的工作簿创建一个新文件夹,因为分割后的Excel文件将保留在与此主工作簿相同的文件夹中。

2。 按住 ALT + F11 在Excel中的键,它打开 Microsoft Visual Basic for Applications 窗口。

3。 点击 插页 > 模块,并将以下代码粘贴到模块窗口中。

VBA:将工作簿拆分为多个工作簿并保存在同一文件夹中

Sub Splitbook()
'Updateby20140612
Dim xPath As String
xPath = Application.ActiveWorkbook.Path
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each xWs In ThisWorkbook.Sheets
    xWs.Copy
    Application.ActiveWorkbook.SaveAs Filename:=xPath & "\" & xWs.Name & ".xlsx"
    Application.ActiveWorkbook.Close False
Next
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub

4。 按 F5 运行这个代码的关键。 然后将工作簿拆分为与原始工作簿位于同一个文件夹中的Excel文件。 看截图:

注意:如果其中一个工作表与工作簿具有相同的名称,则此VBA无法工作。


使用Kutools for Excel轻松拆分工作簿以分离Excel / PDF / CSV / TXT文件

如果你有 Kutools for Excel 安装好了 分割工作簿 工具可以方便快捷地将多个工作表分割为独立的Excel文件,只需点击几下即可。

Kutools for Excel -包括多个用于Excel的300便捷工具。 全功能免费试用30天,无需信用卡! 现在加入

1。 安装后 Kutools for Excel,单击“ Kutools Plus > 分割工作簿 ,看截图:

2。 在 分割工作簿 对话框,请执行以下操作:
(1)默认情况下会检查所有工作表名称。 如果您不想拆分某些工作表,可以取消选中它们;
(2)检查 保存类型 选项;
(3)来自 保存类型 下拉,选择一个你想分割和保存的文件类型。
(4)然后点击 分裂 按钮。

注意:如果你想避免分裂隐藏或空白的工作表,你可以检查 跳过隐藏的工作表 or 跳过空白的工作表 框。

3。 在“浏览文件夹”对话框中,请指定目标文件夹以保存拆分单独文件,然后单击 OK 按钮。

现在,已检查的工作表将另存为新的分隔工作簿。 每个新工作簿都以原始工作表名称命名。 看截图:

Kutools for Excel's 分割工作簿 工具可以根据需要轻松地将活动工作簿拆分为单个Excel文件(一个文件包含一个工作表),CSV文件,TXT文件或PDF文件。 您可以设置跳过所有空白和隐藏的工作表。 免费试用!


演示:将单个工作簿的每个工作表分开或保存为单独的excel / txt / csv / pdf文件

在这个视频中, Kutools Kutools Plus 选项卡添加 Kutools for Excel。 如果需要,请点击 30天免费试用,不受限制!

相关文章:


Kutools for Excel解决了您的大多数问题,并使您的生产率提高了80%

  • 重用: 快速插入 复杂的公式,图表 以及你以前用过的任何东西; 加密单元格 密码; 创建邮件列表 并发送电子邮件...
  • 超级方程式酒吧 (轻松编辑多行文字和公式); 阅读布局 (轻松读取和编辑大量单元格); 粘贴到过滤范围...
  • 合并单元格/行/列 不丢失数据; 分裂细胞含量; 组合重复的行/列...防止重复的细胞; 比较范围...
  • 选择复制或唯一 行; 选择空行 (所有细胞都是空的); 超级查找和模糊查找 在许多工作簿中; 随机选择......
  • 精确复制 多个单元格而不更改公式参考; 自动创建参考 多张表; 插入项目符号,复选框等等......
  • 提取文本,添加文本,按位置删除, 删除空间; 创建和打印分页小计; 在单元格内容和注释之间转换...
  • 超级过滤器 (将过滤方案保存并应用到其他工作表); 高级排序 按月/周/日,频率等; 特殊过滤器 用粗体,斜体......
  • 结合工作簿和工作表; 根据键列合并表; 将数据拆分为多个表格; 批量转换xls,xlsx和PDF...
  • 超过300强大的功能。 支持Office / Excel 2007-2019和365。 支持所有语言。 在您的企业或组织中轻松部署。 全功能30天免费试用。
kte tab 201905

Office选项卡为Office提供选项卡式界面,使您的工作更轻松

  • 在Word,Excel,PowerPoint中启用选项卡式编辑和阅读,Publisher,Access,Visio和Project。
  • 在同一窗口的新选项卡中打开并创建多个文档,而不是在新窗口中。
  • 通过50%提高您的工作效率,每天为您减少数百次鼠标点击!
官方底部
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Gregory Dorvil · 9 days ago
    If I wanted to split the workbook's collection worksheets by fives into workbooks, is that possible? Meaning, If I have 100 worksheets in a workbook, I want to automate using 5 worksheets at a time to make a workbook, which will end with 20 workbooks being made. How do you tweak the code to do this?
  • To post as a guest, your comment is unpublished.
    Gborka · 27 days ago
    VBA works. If not - Probable errors root cause: This VBA cannot handle HIDDEN SHEETS or if one of the sheets has the same name with the workbook.
    • To post as a guest, your comment is unpublished.
      kellytte · 22 days ago
      Hi Gborka,
      You can use the Split Workbook feature of Kutools for Excel, which can export hidden worksheets, and export all worksheets no matter what sheet names are.
  • To post as a guest, your comment is unpublished.
    Влад · 3 months ago
    Спасибо большое, всё работает.
  • To post as a guest, your comment is unpublished.
    Denise · 5 months ago
    Will this VBA work for Mac? It works perfectly for my PC but my manager uses a Mac.
    • To post as a guest, your comment is unpublished.
      Salim · 4 months ago
      Yes!! I just used it on Mac. However you will need to change some thing. The back slash into front slash /. I have already done it. Copy paste it. It will work. Let me know if it doesn't.

      Sub Splitbook()
      'Updateby20140612
      Dim xPath As String
      xPath = Application.ActiveWorkbook.Path
      Application.ScreenUpdating = False
      Application.DisplayAlerts = False
      For Each xWs In ThisWorkbook.Sheets
      xWs.Copy
      Application.ActiveWorkbook.SaveAs Filename:=xPath & "/" & xWs.Name & ".xlsx"
      Application.ActiveWorkbook.Close False
      Next
      Application.DisplayAlerts = True
      Application.ScreenUpdating = True
      End Sub
  • To post as a guest, your comment is unpublished.
    Ambarella · 6 months ago
    The version vba code is not working right, I have a "macros" file where I keep all my macros and have it open when I'm going to use them, and I'm running this one in the file that I need to be splitted but it splits the macros file.
  • To post as a guest, your comment is unpublished.
    User1 · 7 months ago
    Thank you!
  • To post as a guest, your comment is unpublished.
    M. Rameez · 8 months ago
    I found this really help full. Thanks! :)
  • To post as a guest, your comment is unpublished.
    alfonso · 10 months ago
    getting runtime error 1004
    • To post as a guest, your comment is unpublished.
      Christopher Lacey · 4 months ago
      I am as well, I have used this several times in the past but it is not working now
      • To post as a guest, your comment is unpublished.
        Gborka · 27 days ago
        1004 error root cause: This VBA cannot handle hidden sheets or if one of the sheets has the same name with the workbook.
  • To post as a guest, your comment is unpublished.
    Web7 · 1 years ago
    Does anyone know how to make this code work for a mac?
    It is showing an error when trying to locate the document.
  • To post as a guest, your comment is unpublished.
    Ronnie · 1 years ago
    Amazing script and instructions. Just saved me from splitting 30+Worksheets to separate files
    • To post as a guest, your comment is unpublished.
      Kim · 10 months ago
      Same! This worked perfectly for me. Saved me a lot of effort. Thank you!
  • To post as a guest, your comment is unpublished.
    Judy Smith · 1 years ago
    Please disregard my previous post. I have resolved my issue.
  • To post as a guest, your comment is unpublished.
    Judy Smith · 1 years ago
    I am using the split data into worksheets based on a column with 27 items in that column. The results are 54 worksheets 2 for each item. The only difference I can see is based on one of the columns in the range. For example:

    Once the split has occured, John Doe has 2 worksheets, one named John Doe and another named Sheet32. Each sheet has information for John Doe, but based on a column "Status" (Billed, Open Order, Salesforce), the information is split. The named worksheet has Billed & Open Order information and the Sheet32 has Salesforce information.


    Any idea what I am doing wrong?


  • To post as a guest, your comment is unpublished.
    Sreejith · 1 years ago
    That really helped. Thank you.
  • To post as a guest, your comment is unpublished.
    Gabriel · 1 years ago
    With the addition of code from comment below it works realy nice.
  • To post as a guest, your comment is unpublished.
    Paulo Corcino · 1 years ago
    Sub Splitbook()
    'Updateby20140612
    Dim xPath As String
    Dim Sourcewb As Workbook
    Dim Destwb As Workbook
    Dim xWs As Worksheet


    xPath = Application.ActiveWorkbook.Path
    Set Sourcewb = ActiveWorkbook

    With Application
    .ScreenUpdating = False
    .EnableEvents = False
    .Calculation = xlCalculationManual
    End With


    ' For Each xWs In ThisWorkbook.Sheets
    For Each xWs In Sourcewb.Worksheets

    If xWs.Visible = -1 Then
    xWs.Copy
    Set Destwb = ActiveWorkbook
    If Destwb.Sheets(1).ProtectContents = False Then
    With Destwb.Sheets(1).UsedRange
    .Cells.Copy
    .Cells.PasteSpecial xlPasteValues
    .Cells(1).Select
    End With
    Application.CutCopyMode = False
    End If
    With Destwb
    .SaveAs Filename:=xPath & "\" & xWs.Name & ".xlsx"
    .Close False
    End With
    End If
    Next

    With Application
    .ScreenUpdating = True
    .EnableEvents = True
    .Calculation = xlCalculationAutomatic
    End With

    MsgBox "You can find the files in " & xPath

    End Sub
  • To post as a guest, your comment is unpublished.
    Emmanuel · 1 years ago
    Hi, can I add or modify the filename?
  • To post as a guest, your comment is unpublished.
    CMG · 2 years ago
    Hi, can I get VBA to split a file with multiple tabs into separate files and save in their respective folders? i.e. If I have a report with 189 tabs each tab for different clients; can I separate those tabs and save each file in a folder specific to that client? The report varies with the number of tabs through out the month.
  • To post as a guest, your comment is unpublished.
    MAB · 2 years ago
    Hi - Can I get VBA to split a file with multiple tabs into files with multiple tabs? i.e. if I have a file with 2 tabs and data in both tabs with a field called customer -100 customers-, can I get VBA to create one file per customer -100 files- with two tabs each?
  • To post as a guest, your comment is unpublished.
    pippa hatt · 2 years ago
    help ive done this loads of times however today its saying an error on the Application.ActiveWorkbook.SaveAs Filename:=xPath & "\" & xWs.Name & ".xlsx" what am i doing wrong
    • To post as a guest, your comment is unpublished.
      LR · 2 years ago
      You may need to change ".xlsx" on line 9 to ".xls" instead
      • To post as a guest, your comment is unpublished.
        Eben · 1 years ago
        It does that because of the spaces for indentation on lines 8 - 10. Also kept me busy a while to figure out why it's doing that now.
        • To post as a guest, your comment is unpublished.
          Mrs Phillipa L Hatt · 8 months ago
          been using this for a while and now having a run time error 1004 then highlighting in yellow line 8 xWs.copy any ideas please
  • To post as a guest, your comment is unpublished.
    Kelley · 2 years ago
    Hi - instead of splitting each worksheet into a new workbook, is there a way to split groups of worksheets into new workbooks? Ex. Sheet1, Sheet2, Sheet3 go into a workbook, and Sheet4, Sheet5, and Sheet6 go to a second workbook, rather than six new workbooks?
  • To post as a guest, your comment is unpublished.
    tony bones · 2 years ago
    need a vba code to copy an entire workbook (all tabs) and have files saved based on cell range name by state?
  • To post as a guest, your comment is unpublished.
    imran ch · 2 years ago
    thank you very much www.extendoffice.com . very simple and well define post
  • To post as a guest, your comment is unpublished.
    Chris · 2 years ago
    Hi, I have a document of 10 sheets, but I only want the same 8 sheets to copy out each time I hit the command button. What changes can I make to the code (bearing in mind I am a complete amateur in Excel) to get each sheet to adopt the name of the main file, then add the sheet name at the end?

    So as an example the file is called "TESTING" and it has a sheet called "EUROPE". When the macro runs, I want the Europe sheet to be copied out and called "TESTING - EUROPE.xls".
  • To post as a guest, your comment is unpublished.
    adnan · 2 years ago
    Hi
    The coding works well but I want the header also to come on each and every sheet. As it's skipped the header in all data...
  • To post as a guest, your comment is unpublished.
    Karissa Brandhagen · 2 years ago
    How can I get this .xlsx file to save as .csv when split?
  • To post as a guest, your comment is unpublished.
    Nikk · 2 years ago
    Thank you so much! It worked after I unhid the rest of the workbook. This is awesome!
  • To post as a guest, your comment is unpublished.
    Tomm · 2 years ago
    2 questions.

    1. How can you adjust the code the choose the file path of where it is saved? As opposed to just saving wherever the original file is.

    2. How do you change the code to choose what column it creates the tabs from (i.e. in this code it is reading out of column A). I want to be able to choose which column it reads off if. Thanks!
  • To post as a guest, your comment is unpublished.
    Jessica P. · 2 years ago
    Thank you very much for this.Saved me weeks of sweat...
     
    Regards:Jessica
    Active consumer on customerso
  • To post as a guest, your comment is unpublished.
    Anjali · 2 years ago
    Hi, i have one quarry i.e. i have 15000 lines of data in one excel sheet and i want to split that data into multiple excel files where as each file contains 99 lines of data. Anyone can help me. Please share your thoughts.....
  • To post as a guest, your comment is unpublished.
    DS · 2 years ago
    This VBA code worked perfectly. Thank you for sharing your wealth of knowledge.
  • To post as a guest, your comment is unpublished.
    Brad · 2 years ago
    The macro should be updated to include an unhide-all-worksheets piece (including the very-hidden worksheets):

    Sub UnhideAllSheets()
    'Unhide all sheets in workbook.
    Dim ws As Worksheet
    For Each ws In ActiveWorkbook.Worksheets
    ws.Visible = xlSheetVisible
    Next ws
    End Sub

    Sub Splitbook()
    'Updateby20140612
    Dim xPath As String
    xPath = Application.ActiveWorkbook.Path
    Application.ScreenUpdating = False
    Application.DisplayAlerts = False
    For Each xWs In ThisWorkbook.Sheets
    xWs.Copy
    Application.ActiveWorkbook.SaveAs Filename:=xPath & "\" & xWs.Name & ".xlsx"
    Application.ActiveWorkbook.Close False
    Next
    Application.DisplayAlerts = True
    Application.ScreenUpdating = True
    End Sub
  • To post as a guest, your comment is unpublished.
    Brad · 2 years ago
    IT SHOULD BE NOTED THAT THE VBA MACRO ABOVE WON'T WORK IF YOU HAVE A HIDDEN EXCEL SHEET, OR A "VERY-HIDDEN" EXCEL SHEET.

    YOU MAY NOT BE AWARE THAT YOU HAVE A "VERY-HIDDEN" EXCEL SHEET. TO CHECK, HIT ALT+F11 TO OPEN MICROSOFT VISUAL BASIC (MACRO EDITOR). CLICK ON EACH WORKSHEET UNDER THE MICROSOFT EXCEL OBJECTS AND MAKE SURE THAT THE "Visible" ATTRIBUTE IN THE "Properties" SECTION SHOWS "-1 = xlSheetVisible". IF YOU SPIT AN EXCEL FILE OUT OF ORACLE, FOR EXAMPLE, YOU'LL SEE A WORKSHEET NAMED "BneLog" with visibility = "2 - xlSheetVeryHidden". This took me forever to figure out, lol. Hope it helps!
    • To post as a guest, your comment is unpublished.
      David · 2 years ago
      Great tip! I was beating my head against a wall until this occurred to me. I saw previous comments about hidden sheets but until I realized an existing macro was "very hidden", it didn't make sense to me. On to the next project!
  • To post as a guest, your comment is unpublished.
    sunil · 2 years ago
    Used this and it worked. Just what I needed. Thanks
  • To post as a guest, your comment is unpublished.
    Jignesh S Thakrar · 3 years ago
    Hi

    I'm have master file were data consist for multiple city would like know is their any macros or any formula which keeps this orignal file and also create & update new workbook city area wise
  • To post as a guest, your comment is unpublished.
    Snehalata Gupta · 3 years ago
    Hello all,

    I need to reciprocate the same thing.

    there are lots of excel sheets and i want it te 1st sheet of it in single work book,
    Please Help!!!!
  • To post as a guest, your comment is unpublished.
    Bakhty · 3 years ago
    VBA script worked like a charm, got my 80+ new excel files
  • To post as a guest, your comment is unpublished.
    shanojirao · 3 years ago
    Hi All,

    I need a help from you all,

    I've to share the reports to multiple team depending on the brands they work for.

    Eg: brand name:
    Apple
    Samsung
    and many more around 60 brands.

    there will be a sales dump.

    If I want to run a macro, and spilt into multiple excel files what would be the procedure.

    Kindly help me.

    Thanks in Advance.

    Regards,
    Shan
  • To post as a guest, your comment is unpublished.
    Rogier van Meggelen · 3 years ago
    The code works great. Can you also use this to save the tabs as pdf files.
    It can't figure this out :)
  • To post as a guest, your comment is unpublished.
    Rogier van Meggelen · 3 years ago
    The code works great! is it also possible to save the different tabs as a pdf? I tried but the i can't get it to work :)
  • To post as a guest, your comment is unpublished.
    Anandaraj.M · 3 years ago
    Thanks for your valuable support
  • To post as a guest, your comment is unpublished.
    Stephanie · 3 years ago
    The VBA code worked beautifully! It saved me so much time. Thank you for sharing!
  • To post as a guest, your comment is unpublished.
    Adrian Rees · 3 years ago
    Thanks, vba code worked perfectly! Saved me a lot of time splitting a spreadsheet with 25 tabs into different files.

    Only thing i picked up is in the 6th last line i changed the file format to new Excel "xlsx"

    " & xWs.Name & ".xls" becomes >>>>> " & xWs.Name & ".xlsx"
  • To post as a guest, your comment is unpublished.
    Herb · 3 years ago
    Thanks for the VBA code!!. It worked perfectly. Saved me much work!!
  • To post as a guest, your comment is unpublished.
    NG · 3 years ago
    Hi there,

    Thank you so much for the code, however may how you would add to the code if you wanted the following to happen?
    1. What if you wanted Sheet 1 to be copied as well for each additional sheets?

    For example, the newly created
    1. "Sheet 2" would have "Sheet 1 and Sheet 2"
    2. "Sheet 3" would have "Sheet 1 and Sheet 3"

    and so on and so forth.

    Appreciate if you could provide any help with this. Thank you.
  • To post as a guest, your comment is unpublished.
    zirokl · 3 years ago
    Thank you so much for this! It is amazing, works perfectly.

    But is it possible to modify it so it saves each worksheet to the same directory(without creating a new folder) based on original file name or particular Cell Value? Just by adding (1), (2) ets at the end of each exported file.

    Greatly appreciate your help.
  • To post as a guest, your comment is unpublished.
    NG · 3 years ago
    you saved my day with this code!!
  • To post as a guest, your comment is unpublished.
    Ovi · 3 years ago
    Is there a way I can apply the split to many excel files at once? The files have the same 2 sheets (as format and name).
    Thank you!
  • To post as a guest, your comment is unpublished.
    Brian · 4 years ago
    Hello, Thank you; super helpful. I was curious how to edit the save directory. When I run this code, it saves one directory up from the directory the original file is saved. Can someone please tell me how to make it save to the source file's directory?
  • To post as a guest, your comment is unpublished.
    Sam · 4 years ago
    I am having data for all the 365 days for 14 year in one excel sheet.

    Now we want to separate the data year wise (Ex. one excel file for year 2002 in that 12 Sheet ie for 12 month and another excel file for year 2003 in that 12 Sheet ie for 12 month).

    We are able to separate month wise data (by using Excel Kutools - Split Data) and it will create excel sheet for each month (ie it will create totally 24 sheets) and then we should Split to Workbook and it will be 24 excel file and again we should combine 12 file for each year. This is taking lot of time.

    Now our problem is while splitting the date we want Excel to create Year wise Excel files and in each excel file 12 sheets for 12 months. Can we do this in same time.

    Please tell us because we are having lots of data and it is taking lot of time.
  • To post as a guest, your comment is unpublished.
    Caroline · 4 years ago
    Hi - I have a work sheet with a lot of data that I need to split into separate sheets so I can attach and email to various people. Do you know how I would go about this? I have a TOTAL cell for each batch of data that I need to split, not all the batches contain the same number of lines. Any help you can give would be greatly appreciated. Thank you.