abstracting data subsets from Numbers
by naturist - 12/26/09 6:36 PM
Forgive me if this has been asked and answered before, but given that the search function here is utterly useless, I'm hoping somebody won't mind helping me out.
I have a donor list from which I wish to extract individual statements. For a other reasons, it exists now as an Excel spreadsheet, which I have read into Numbers ('08 version), and I can't figure out how to take single lines of data and make those individual statements, save one by one, by hand, cut and paste.
I could do a mail merge in Appleworks, if I had the data in an Appleworks database, although constructing that database would be a major pain. Is there any way to create separate sheets and have the data function relative to the main sheet? That is, could it be made so that an entry on sheet one would automatically be reflected in the data on say sheet 23?