\
  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...
Salmon trailer park generalized bond
  05/09/25
workbook*
stubborn dingle berry set
  05/09/25
Yes both websites that can do it and like three clicks in ex...
Bull Headed Dun Elastic Band
  05/09/25
never heard of it
Salmon trailer park generalized bond
  05/09/25
are you asking if you can extract the individual tabs in an ...
Red yapping gaping
  05/09/25
Yes, you fucking retard, obviously that is what he is asking...
Soggy 180 boistinker
  05/09/25
have AI do it not flame
hateful headpube
  05/09/25
You really had to make this thread in the age of ChatGPT? Al...
Duck-like Garrison Son Of Senegal
  05/09/25
Print each sheet individually and scan to pdf
floppy glassy death wish theater
  05/09/25
finaly a helpful answer
Salmon trailer park generalized bond
  05/09/25
...
ruby scourge upon the earth lay
  05/09/25
...
Bull Headed Dun Elastic Band
  05/09/25
Sub SplitSheetsToFiles() Dim ws As Worksheet Dim wb As...
cordovan vibrant fortuitous meteor
  05/09/25
u should have charged for that
Bull Headed Dun Elastic Band
  05/09/25
Lol is that a macro lmao
Talented Jap Locale
  05/09/25
dont worry im sure a guy who cant figure out how to manually...
Bull Headed Dun Elastic Band
  05/09/25
I used to macro the shit out of my 486 but his sample has sy...
Salmon trailer park generalized bond
  05/09/25
https://chatgpt.com/ brother you can just go here and giv...
hateful headpube
  05/09/25
...
Talented Jap Locale
  05/09/25
...
Bull Headed Dun Elastic Band
  05/09/25
define "lots"
Snowy Jew
  05/09/25
openpyxl + gpt
heady pearly round eye milk
  05/09/25


Poast new message in this thread



Reply Favorite

Date: May 9th, 2025 1:00 PM
Author: Salmon trailer park generalized bond

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: stubborn dingle berry set

workbook*

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



Reply Favorite

Date: May 9th, 2025 1:01 PM
Author: Bull Headed Dun Elastic Band

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: Salmon trailer park generalized bond

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: Red yapping gaping

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: Soggy 180 boistinker

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: hateful headpube

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: Duck-like Garrison Son Of Senegal

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: floppy glassy death wish theater

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: Salmon trailer park generalized bond

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: ruby scourge upon the earth lay



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



Reply Favorite

Date: May 9th, 2025 1:32 PM
Author: Bull Headed Dun Elastic Band



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



Reply Favorite

Date: May 9th, 2025 1:35 PM
Author: cordovan vibrant fortuitous meteor

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: Bull Headed Dun Elastic Band

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: Talented Jap Locale

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: Bull Headed Dun Elastic Band

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: Salmon trailer park generalized bond

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: hateful headpube

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: Talented Jap Locale



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



Reply Favorite

Date: May 9th, 2025 2:14 PM
Author: Bull Headed Dun Elastic Band



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



Reply Favorite

Date: May 9th, 2025 1:40 PM
Author: Snowy Jew

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: heady pearly round eye milk

openpyxl + gpt

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