\
  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...
turquoise orchestra pit kitty
  05/09/25
workbook*
Mustard aromatic house
  05/09/25
Yes both websites that can do it and like three clicks in ex...
stubborn soul-stirring nibblets
  05/09/25
never heard of it
turquoise orchestra pit kitty
  05/09/25
are you asking if you can extract the individual tabs in an ...
Big Flesh Area Karate
  05/09/25
Yes, you fucking retard, obviously that is what he is asking...
misanthropic spot dragon
  05/09/25
have AI do it not flame
Peach boistinker selfie
  05/09/25
You really had to make this thread in the age of ChatGPT? Al...
Emerald blathering menage
  05/09/25
Print each sheet individually and scan to pdf
Brindle Roommate
  05/09/25
finaly a helpful answer
turquoise orchestra pit kitty
  05/09/25
...
Orchid dashing people who are hurt property
  05/09/25
...
stubborn soul-stirring nibblets
  05/09/25
Sub SplitSheetsToFiles() Dim ws As Worksheet Dim wb As...
salmon location factory reset button
  05/09/25
u should have charged for that
stubborn soul-stirring nibblets
  05/09/25
Lol is that a macro lmao
odious feces university
  05/09/25
dont worry im sure a guy who cant figure out how to manually...
stubborn soul-stirring nibblets
  05/09/25
I used to macro the shit out of my 486 but his sample has sy...
turquoise orchestra pit kitty
  05/09/25
https://chatgpt.com/ brother you can just go here and giv...
Peach boistinker selfie
  05/09/25
...
odious feces university
  05/09/25
...
stubborn soul-stirring nibblets
  05/09/25
define "lots"
Sienna hospital
  05/09/25
openpyxl + gpt
deep lascivious stag film personal credit line
  05/09/25


Poast new message in this thread



Reply Favorite

Date: May 9th, 2025 1:00 PM
Author: turquoise orchestra pit kitty

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: Mustard aromatic house

workbook*

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



Reply Favorite

Date: May 9th, 2025 1:01 PM
Author: stubborn soul-stirring nibblets

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: turquoise orchestra pit kitty

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: Big Flesh Area Karate

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: misanthropic spot dragon

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: Peach boistinker selfie

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: Emerald blathering menage

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: Brindle Roommate

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: turquoise orchestra pit kitty

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: Orchid dashing people who are hurt property



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



Reply Favorite

Date: May 9th, 2025 1:32 PM
Author: stubborn soul-stirring nibblets



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



Reply Favorite

Date: May 9th, 2025 1:35 PM
Author: salmon location factory reset button

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: stubborn soul-stirring nibblets

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: odious feces university

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: stubborn soul-stirring nibblets

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: turquoise orchestra pit kitty

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: Peach boistinker selfie

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: odious feces university



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



Reply Favorite

Date: May 9th, 2025 2:14 PM
Author: stubborn soul-stirring nibblets



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



Reply Favorite

Date: May 9th, 2025 1:40 PM
Author: Sienna hospital

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: deep lascivious stag film personal credit line

openpyxl + gpt

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