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?
-
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.– AlexCommented Feb 27, 2019 at 2:59
-
1If 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
Add a comment
|