Mac Applications forum

General discussion

abstracting data subsets from Numbers

by naturist / December 26, 2009 10:36 AM PST

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?

Post a reply
Discussion is locked
You are posting a reply to: abstracting data subsets from Numbers
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: abstracting data subsets from Numbers
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Collapse -
Numbers
by mrmacfixit Forum moderator / December 28, 2009 9:33 AM PST

"That is, could it be made so that an entry on sheet one would automatically be reflected in the data on say sheet 23?"

Create the spreadsheet. In Numbers, sheets are called Tables. Create the tables you want, I only created 2 to test this.

On the second sheet, select a cell and in the formula line, put an = sign. Go to the first sheet and click the cell that you want to take the data from. Accept the formula in sheet 2.

Now anything entered into that cell on sheet one, will also appear in the cell you chose on sheet 2.

Is that what you are trying to do??

P

Collapse -
ahhhh
by naturist / December 29, 2009 9:03 AM PST
In reply to: Numbers

thank you. I think that will do it.

Collapse -
Wow!
by mrmacfixit Forum moderator / December 29, 2009 9:15 AM PST
In reply to: ahhhh

I was prepared for the "not quite what I meant" answer.

Glad it will work for you

P

Popular Forums
icon
Computer Help 47,885 discussions
icon
Computer Newbies 10,322 discussions
icon
iPhones, iPods, & iPads 3,188 discussions
icon
Security 30,333 discussions
icon
TVs & Home Theaters 20,177 discussions
icon
HDTV Picture Setting 1,932 discussions
icon
Phones 15,713 discussions
icon
Windows 7 6,210 discussions
icon
Networking & Wireless 14,510 discussions

Tech for the school year

Smart tech for smart students

Forget the pencils and notebooks. Gear up your students with these portable and powerful note-taking machines.