Help this is probably dumb. I have a workbook with 30 tabs. Is there a quick way to separate each in to its own book or should I copy one a time?

like
Posting as :
works at
You are currently posting as works at

Don’t know of any specific function to do this more quickly. Would have to write a macro I think.

like

Here: https://www.extendoffice.com/documents/excel/628-excel-split-workbook.html

Start reading from the section: Split a Workbook To Separate Excel Files with VBA Code

like

Click on the first tab hold shift click on the 6th one (if you want 1-6 for example) then right click and copy to new workbook

like

The former lol

likefunny

Doing 30 manually using A1s technique will not take you long at all.

like

Google the macro for it > copy paste macro into excel > run macro > profit

like

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

likehelpful

Oh didn’t see the for each statement. Cool

like

ASAP utilities. Student edition will help.

What sorcery is this?

I'd probably "save as", "save as" multiple times, then just delete the tables -vs- copy paste. 🤷

Oof

Related Posts

What salary should I expect at the AE level (one level about assistant account executive) at an agency?

like

What are some good retail companies to work for?

like

Friday 4/2/21
Happy Holy Week Saints!
Reflection on the Death, Burial and Resurrection of Christ:
What does Christ’s death mean to our world and what does it mean to you?
◄ Isaiah 53:5 ►
But he was wounded for our transgressions, he was bruised for our iniquities: the chastisement of our peace was upon him; and with his stripes we are healed.
Pray for a multitude to come to know Jesus our Messiah and Lord.

like

It's that time of the week again 😓

like

Anyone want to share…What insurance companies would you recommend working for and what positions are available?

like

I just got laid off from an organisation, i have 1 year 11 months of experience in cloud operations (AWS/AZURE). Can someone please guide me what can be done next.

like

Has your company been trying to get staff back in with “perks” or “events”? Why can’t they get the memo that no one actually wants to go in at this point? I’m running out of excuses to say on why I’m not coming in

likesmart

Does anyone has idea about relocation assistance offered by companies?
How this process works

How does one get over a retraction of offer by employer ?

like

Is anyone really working this week (good thing and bad thing)?
I have been trying to ask for billing with partners and there is no OOO reply.
I feel like I’m being ghosted.

How is work life balance in fis gurgaon?

like

Seeking internal referrals or to connect with TA of American Express.
Any help regarding this would be greatly appreciated.
Position applied for: Legal Operations Specialist.

like

Lay-off thread. PwC hasn’t announced any yet nor have I heard off any. Please post about your company.

like

How to push for promotion? I am doing much more and much better than peers at the level above me. Ie: level of hires, time to fill, number of hires, building partnerships with internal stakeholders. Being recognized by candidates, hiring managers, nominations for awards each quarter, winning a couple. Been in this role for 1 year, foot on the gas the whole time.

like

Hello Everybody,

I just got mail that I have cleared technical and managerial round for big data developer position for Cognizant.

I have 6 yrs of exp in IT. Current CTC is 13.4 lpa

Now next round is HR round.

How much package should I ask for.

And also i have 90 days notice period, will they agree.

Please guide how to handle this HR Round.
will be a lot of help 🙏

I want to know from HR or senior management that do you offer less to female candidate provided she has same skills as a male candidate?
Does in IT industry gender doesn't impact compensation?

Hi fishes. I am social work professional with 6 YOE in international NGOs. I am looking for opportunities in CSR / INGO /Consulting firms / Impact organisations. Please share if there are any leads.
I have worked in Education, Skill development, Child protection, Health and Adolescent and youth empowerment domains.
Preferred location : Bangalore, Mumbai

like

Does deloitte salary match an another firms offer for the same role?

like

Anyone have recommendations on larger messenger bags (ideally something that could fit a laptop, water bottle, notebook and binder) that can still look stylish? TIA

Additional Posts in Excel Genius

I’m using a pivot table to show how different initiatives fall under broader themes. If I’m screen sharing the pivot table w my audience and we make a live edit to one of the initiatives on the table itself, is there a way this can also change the initiative in the source data?

like

My excel columns have switched to numbers (so I know have numbers for columns and rows). This has also made all of my formulas incredibly confusing. Was this part of some update? How can I switch my columns back to letters?

like

Hi Geniuses. I’m needing to write some compounded if statements and use VSlookup to analyze, group and report based on data in a dataset. Anyone have a decent learning source? Google and YouTube have returned some hard to follow, bad results that miss the mark.

like

How do you calculate the “rate of change” within excel? I am comparing the number of bugs from one week to another.

like

Hi, in my excel pivot table slicer I have my options and then (blanks) option , anyway to get rid of that?

I’m looking to make a supplier list where I can just filter on certain requirements to get a smaller list…currently creating as a pivot table but is there any other options that make sense?

Post Photo
like

Anyone know why my wildcards * are not working consistently in sumifs? If I combine multiple sumifs in one formula using + the wildcard only works in some parts. In other parts I need to specify the exact full text which makes my formula lengthier than needed. For example, "app*" isn't picking up "application" and "apple" so I need two separate sumifs to pick up these two.

like

I’m trying to consolidated planning of FTEs from weeks to fiscal periods in a new table. If my column heading in the original table is 1, 2, 3 etc and my new table is Period 1, Period 2 etc
What is the most efficient formula to do this? Just doing =sum(Hours!E7:H7) for each period will take forever… thank you!!

like

I'd like to know if anyone has ever pressed the excel help key (f1) on purpose. It is literally the most useless and obnoxious shortcut for excel. I accidentally press it 5 times a day at least.

likefunny

I'm stumped!
Coworker creates "Sheet A" with invoice numbers
I use Monarch to extract invoice #'s and amounts from another report.
I do a pivot table to compile amounts by invoice. I copy those results to "Sheet Z".
I then do an @vlookup on Sheet A referencing Sheet Z (just the invoice # and amount).
It isn't working unless I go to Sheet Z and type over the invoice # (same number)! All invoice #'s are absolute and in the same font & alignment. Workbook has 10 yrs data. Has worked in past!

like

Story time: I was on a trip about 15 years back, doing some Excel work on a ferry ride - your basic pseudo-database work that is so common. I started talking with the guy sitting next to me and after a while he commented on what I was doing, “You know, that’s really not what I designed that for…” (continued)

likefunny

Anyone know of an Excel plugin that acts as a reference calendar for Federal Reserve holidays (and those observed)?

like

Need to build a macro or python script to convert client spreadsheets to an import template. They are storing a process ID, metadata asset 1 (col B), metadata asset 1 attribute 1, asset 2 (col D), and asset 2 attribute on a single line. On our template, that should be 2 rows and then assign certain values based on the row being populated by col B/D. At a high level does this sound macro worthy or just start with python? I can give more details if needed.

like

Does anyone know if Excel is compatable with Adobe Sign/PDF? I'm trying to automate data entry from Adobe sign/PDF to an Excel sheet. Adobe

like

Anyone know how to delete multiple custom cell styles at once without running a macro?

Is there a way/shortcut, without using a mouse to drag cells down, to fill a range of data following a trend? I want a column with the first day of each month up to a certain date (row number). Thanks

In VBA when sending an email. How do I change the reply to email?

like

Hi Gang, I have voluminous pdf bank statements that I want to convert to excel with the formatting. What’s the easiest way out?

like

How would I create subtotal rows in a table? A true table, I dont want to turn my table into a range because I need the other sorting features.

likehelpful

Anyone have thoughts on best VBA/macro training out there? I find there are so many things I could automate and need a good place to learn the basics (particularly for excel).

like

How TF do I attach the SharePoint version of a slide deck in an email? Every time I try to share, it gives me the link in the email body instead of an actual attachment to open in app. PLEASE AND THANK YOU

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal