Can I combine two files to be two sheets in one file?
well can I? And if so, how? Not sure how to explain in more detail, but I can try if need be. Help me?!
iMac, OS X Mavericks (10.9), 20" (early 2008)
well can I? And if so, how? Not sure how to explain in more detail, but I can try if need be. Help me?!
iMac, OS X Mavericks (10.9), 20" (early 2008)
Hi SharpieJeff,
Within a sheet, with nothing selected, you can select all and copy.
If you open a new doc you can paste all the tables into a sheet. As long as there were no links to other sheets everything will work great. You can repeat from the other document.
quinn
I Was hoping for a simple drag& drop type solution because I have 50-60 spreadsheets to combine Into an accounts receivable ledger. Or something like that.
Hi SharpieJeff,
When you say 50-60 spreadsheets you mean separate Numbers files right? In each file, how many sheets with how many tables ? If there is consistency, it is possible that a script could be written that would bring things together. It is currently beyond me but there are people on this forum that could build one.
quinn
Bingo,Quinn! Each numbers file contains one spreadsheets or one "table" and every "table" is a copy of the original. Totally uniform. Where can I learn about "scripts"???
Hi SharpieJeff,
SG, who offered a simple script on another of your topics is one of the scripting wizards on the Numbers forum. I am beginning to find my way within a Numbers file but reading a bunch of files into 1 is something I haven't attempted yet. Numbers 3 is very script savvy so it can be a very useful tool. A script I am using with some frequency updates certain popups on several sheets in a file.
One helpful website is http://macosxautomation.com/applescript/firsttutorial/index.html
You need to know that each Numbers file or document can contain many sheets. Each of those sheets can contain many tables. You might also hear a file refered to as a spreadsheet. The distinctions will be important if you being to script.
quinn
Can I combine two files to be two sheets in one file?