The most prestigious law school admissions discussion board in the world.
|
 |
 
|
Easy way to split up an Excel spreadsheet?
Poast new message in this thread
Date: May 9th, 2025 1:00 PM Author: transparent tank giraffe 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 |
 |
Date: May 9th, 2025 2:28 PM Author: cruel-hearted bawdyhouse workbook* (http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917322) |
Date: May 9th, 2025 1:01 PM Author: Cobalt point Yes both websites that can do it and like three clicks in excel
Use google u dumb fuck boomer |
|
Date: May 9th, 2025 1:06 PM Author: transparent tank giraffe never heard of it (http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917040) |
|
Date: May 9th, 2025 1:01 PM Author: Bull headed razzle set 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) |
|
Date: May 9th, 2025 1:53 PM Author: Lavender trip kitchen Yes, you fucking retard, obviously that is what he is asking. (http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917213) |
|
Date: May 9th, 2025 1:03 PM Author: Boyish drab volcanic crater have AI do it not flame (http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917017) |
|
Date: May 9th, 2025 1:04 PM Author: Cracking silver ticket booth 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) |
|
Date: May 9th, 2025 1:08 PM Author: lascivious red marketing idea Print each sheet individually and scan to pdf (http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917044) |
|
Date: May 9th, 2025 1:09 PM Author: transparent tank giraffe finaly a helpful answer (http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917053) |
|
Date: May 9th, 2025 1:13 PM Author: heady school (http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917072) |
|
Date: May 9th, 2025 1:32 PM Author: Cobalt point (http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917148) |
|
Date: May 9th, 2025 1:35 PM Author: Odious national security agency internal respiration 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 |
|
Date: May 9th, 2025 1:56 PM Author: Cobalt point u should have charged for that (http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917228) |
|
Date: May 9th, 2025 1:57 PM Author: opaque becky Lol is that a macro lmao (http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917231) |
|
Date: May 9th, 2025 1:58 PM Author: Cobalt point 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) |
|
Date: May 9th, 2025 2:00 PM Author: transparent tank giraffe 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 |
|
Date: May 9th, 2025 2:02 PM Author: Boyish drab volcanic crater 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 |
|
Date: May 9th, 2025 2:04 PM Author: opaque becky (http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917254) |
|
Date: May 9th, 2025 2:14 PM Author: Cobalt point (http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917285) |
|
Date: May 9th, 2025 1:40 PM Author: exhilarant claret institution define "lots" (http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48917180) |
|
Date: May 9th, 2025 10:20 PM Author: buck-toothed indecent orchestra pit background story openpyxl + gpt (http://www.autoadmit.com/thread.php?thread_id=5722762&forum_id=2#48918525) |