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 -
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??


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

thank you. I think that will do it.

Collapse -
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


Popular Forums
Computer Help 49,613 discussions
Computer Newbies 10,349 discussions
Laptops 19,436 discussions
Security 30,426 discussions
TVs & Home Theaters 20,308 discussions
Windows 10 360 discussions
Phones 15,802 discussions
Windows 7 7,351 discussions
Networking & Wireless 14,641 discussions


Free trip to the Grand Prix

Don't miss your chance to win a trip to the Formula 1 Grand Prix in Monaco for you and a plus-one.