Skip navigation

Membership type database

277 Views 7 Replies Latest reply: Feb 19, 2013 6:46 PM by Badunit RSS
Beki18 Calculating status...
Currently Being Moderated
Feb 19, 2013 12:33 PM

I have no problems creating a user friendly, efficient database to organize members and be able to quickly locate them in a search mode. However, I am having issues translating it to Excel and remaining as user friendly and efficient. Anyone have any ideas??? Thanks!!!

MacBook Pro, OS X Mountain Lion (10.8.2)
  • Jerrold Green1 Level 7 Level 7 (28,190 points)
    Currently Being Moderated
    Feb 19, 2013 12:35 PM (in response to Beki18)

    Beki18 wrote:

     

    I have no problems creating a user friendly, efficient database to organize members and be able to quickly locate them in a search mode. However, I am having issues translating it to Excel and remaining as user friendly and efficient. Anyone have any ideas??? Thanks!!!

    What features do you seek to preserve?

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,190 points)
    Currently Being Moderated
    Feb 19, 2013 1:13 PM (in response to Beki18)

    Beki,

     

    Categories is a Viewer peculiar to Numbers. It won't export. You could create tables with an organization similar to the Categories view and export that document with its manually created summaries.

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,190 points)
    Currently Being Moderated
    Feb 19, 2013 1:41 PM (in response to Beki18)

    So then, just get your associates to purchase Macs and Numbers so you don't need to export.

     

    Jerry

  • Badunit Level 6 Level 6 (10,760 points)
    Currently Being Moderated
    Feb 19, 2013 6:46 PM (in response to Beki18)

    I don't know of a way to do it in Excel. And for sure I don't know a way that would import/export with Numbers. 

     

    The closest thing I know of in Excel is the "Group" feature (found in the Data tab of Excel).  But this requires you to sort the table, add a new column to the left and a new row for each category name, manually put the category names in the new column, select rows for a particular category, Group, select the rows for the next category, Group, etc. Subcategories would require doing the same thing one level down. All manual processes. There is something called "auto outline" but I can't figure out what it needs to work, it won't auto-anything for me. But if you figure it out, maybe it helps automate the process some (or maybe it does something else entirely).

     

    Rows 1 & 4 and column A are the ones I added for category headings. You use the minus signs on the left to collapse a group. The group for Category 1 is rows 2&3 (not including row 1 or the heading will collapse/hide as well)

     

    Screen Shot 2013-02-19 at 9.39.46 PM.png

     

    Bottom line: A royal pain.

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.