1

I have been given a spreadsheet with 4 separate tabs/sheets. I would like to separate them into different files. I know that I can cut-and-paste and create new files but is there a simpler/easier way to do that?

2
  • AppleScript can do it, but for 4 tabs, unless this was a frequently run process, it wouldn't be simpler or easier than copy/pasting 8 times. See something like: discussions.apple.com/thread/2613193 Would obviously need adjusting to your specific requirements.
    – Alex
    Commented Feb 27, 2019 at 2:59
  • 1
    If this was a once-off situation, I'd just save the file four times and then edit each one to remove the three sheets you don't want.
    – Monomeeth
    Commented Mar 4, 2019 at 21:23

0

You must log in to answer this question.

Browse other questions tagged .