\
  The most prestigious law school admissions discussion board in the world.
BackRefresh Options Favorite

Easy way to split up an Excel spreadsheet?

I have a spreadsheet that is made of lots of individual shee...
ceci n'est pas un avocat
  05/09/25
workbook*
Trump is the first woman President (TT6)
  05/09/25
Yes both websites that can do it and like three clicks in ex...
permanently delayed gratification
  05/09/25
never heard of it
ceci n'est pas un avocat
  05/09/25
are you asking if you can extract the individual tabs in an ...
Jonald J. Trump
  05/09/25
Yes, you fucking retard, obviously that is what he is asking...
Ass Sunstein
  05/09/25
have AI do it not flame
trad cath gook
  05/09/25
You really had to make this thread in the age of ChatGPT? Al...
.- .-. . .-. . .--. - .. .-.. .
  05/09/25
Print each sheet individually and scan to pdf
Pierbattista Pizzaballa
  05/09/25
finaly a helpful answer
ceci n'est pas un avocat
  05/09/25
...
blow off some steam
  05/09/25
...
permanently delayed gratification
  05/09/25
Sub SplitSheetsToFiles() Dim ws As Worksheet Dim wb As...
.;:..;:.;.:.;.,,,..,.:,.;....;,;;;..;,..,,.,,....,
  05/09/25
u should have charged for that
permanently delayed gratification
  05/09/25
Lol is that a macro lmao
metaphysics is fallow
  05/09/25
dont worry im sure a guy who cant figure out how to manually...
permanently delayed gratification
  05/09/25
I used to macro the shit out of my 486 but his sample has sy...
ceci n'est pas un avocat
  05/09/25
https://chatgpt.com/ brother you can just go here and giv...
trad cath gook
  05/09/25
...
metaphysics is fallow
  05/09/25
...
permanently delayed gratification
  05/09/25
define "lots"
its over 100k again
  05/09/25
openpyxl + gpt
Total Nigger Death
  05/09/25


Poast new message in this thread



Reply Favorite

Date: May 9th, 2025 1:00 PM
Author: ceci n'est pas un avocat

I have a spreadsheet that is made of lots of individual sheets. Is there any non-tedious way to automatically have each of those individual sheets split into separate Excel files?

Thanks and please Bill this time to client development

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917011)



Reply Favorite

Date: May 9th, 2025 2:28 PM
Author: Trump is the first woman President (TT6)

workbook*

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917322)



Reply Favorite

Date: May 9th, 2025 1:01 PM
Author: permanently delayed gratification

Yes both websites that can do it and like three clicks in excel

Use google u dumb fuck boomer

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917013)



Reply Favorite

Date: May 9th, 2025 1:06 PM
Author: ceci n'est pas un avocat

never heard of it

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917040)



Reply Favorite

Date: May 9th, 2025 1:01 PM
Author: Jonald J. Trump

are you asking if you can extract the individual tabs in an Excel workbook and save them as separate files?

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917014)



Reply Favorite

Date: May 9th, 2025 1:53 PM
Author: Ass Sunstein

Yes, you fucking retard, obviously that is what he is asking.

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917213)



Reply Favorite

Date: May 9th, 2025 1:03 PM
Author: trad cath gook

have AI do it not flame

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917017)



Reply Favorite

Date: May 9th, 2025 1:04 PM
Author: .- .-. . .-. . .--. - .. .-.. .

You really had to make this thread in the age of ChatGPT? All AI is good for is fucking around with Excel sheets.

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917021)



Reply Favorite

Date: May 9th, 2025 1:08 PM
Author: Pierbattista Pizzaballa

Print each sheet individually and scan to pdf

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917044)



Reply Favorite

Date: May 9th, 2025 1:09 PM
Author: ceci n'est pas un avocat

finaly a helpful answer

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917053)



Reply Favorite

Date: May 9th, 2025 1:13 PM
Author: blow off some steam



(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917072)



Reply Favorite

Date: May 9th, 2025 1:32 PM
Author: permanently delayed gratification



(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917148)



Reply Favorite

Date: May 9th, 2025 1:35 PM
Author: .;:..;:.;.:.;.,,,..,.:,.;....;,;;;..;,..,,.,,....,


Sub SplitSheetsToFiles()

Dim ws As Worksheet

Dim wb As Workbook

Dim savePath As String

' Set the save path

savePath = "C:\Your\Save\Path\" 'Replace with your desired path

' Loop through each sheet

For Each ws In ThisWorkbook.Sheets

' Create a new workbook

Set wb = Workbooks.Add

' Copy the sheet to the new workbook

ws.Copy Before:=wb.Sheets(1)

' Rename the sheet in the new workbook

wb.Sheets(1).Name = ws.Name

' Save the new workbook

wb.SaveAs Filename:=savePath & ws.Name & ".xlsx"

' Close the new workbook (optional)

wb.Close

Next ws

End Sub

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917164)



Reply Favorite

Date: May 9th, 2025 1:56 PM
Author: permanently delayed gratification

u should have charged for that

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917228)



Reply Favorite

Date: May 9th, 2025 1:57 PM
Author: metaphysics is fallow

Lol is that a macro lmao

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917231)



Reply Favorite

Date: May 9th, 2025 1:58 PM
Author: permanently delayed gratification

dont worry im sure a guy who cant figure out how to manually do it can figure out how to use visual basic in excel

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917237)



Reply Favorite

Date: May 9th, 2025 2:00 PM
Author: ceci n'est pas un avocat

I used to macro the shit out of my 486 but his sample has syntax errors and I'm too old to troubleshoot this

I'll just explain to the secretary what I want done about 8-12 times, and maybe it'll be finished by next Wednesday

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917244)



Reply Favorite

Date: May 9th, 2025 2:02 PM
Author: trad cath gook

https://chatgpt.com/

brother you can just go here and give it to your AI gf and she will do it for you in 2 seconds i'm not flaming

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917249)



Reply Favorite

Date: May 9th, 2025 2:04 PM
Author: metaphysics is fallow



(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917254)



Reply Favorite

Date: May 9th, 2025 2:14 PM
Author: permanently delayed gratification



(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917285)



Reply Favorite

Date: May 9th, 2025 1:40 PM
Author: its over 100k again

define "lots"

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917180)



Reply Favorite

Date: May 9th, 2025 10:20 PM
Author: Total Nigger Death

openpyxl + gpt

(http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48918525)