1. karma3's Avatar
    I am in a band and would like to take better control of our song list. We have a spreadsheet master list of our songs that contains 9 fields of info: song name, key, what each member is playing/doing etc. We create set lists from this master. Here's the thing though that I can't get a regular spreadsheet to do. If I make a change to the master, say we change the key we are playing the song in, I want it to change the entry in the set list.
    Since a regular spreadsheet doesn't treat other work pages as aliases like iTunes treats playlists, I have to repeat any changes I make on multiple sheets.
    Anyone know of a "spreadsheet" that acts more like iTunes? I don't need any formula ability, just the availability of multiple fields and sorting options.
    07-24-2015 02:33 PM
  2. SwitchBeach's Avatar
    Have you tried using a database program (such as Access) and creating queries?

    Or in Excel, when you create the playlists, have the cell in the playlist sheet be a reference to the master list sheet (rather than a straight copy-and-paste entry)?
    07-24-2015 04:31 PM
  3. Ledsteplin's Avatar
    07-25-2015 10:34 AM

Similar Threads

  1. Mail Pilot 2 for Mac enters public preview, offers 50% off for testers
    By iMore.com in forum iMore.com News Discussion
    Replies: 2
    Last Post: 07-26-2015, 07:16 PM
  2. Replies: 6
    Last Post: 07-24-2015, 01:53 PM
  3. Replies: 0
    Last Post: 07-24-2015, 01:00 PM
  4. Why doesn't my iPhone show up in my iTunes?
    By iMore Question in forum iTunes
    Replies: 1
    Last Post: 07-24-2015, 10:51 AM
  5. Best rugged back-up batteries for iPhone
    By iMore.com in forum iMore.com News Discussion
    Replies: 0
    Last Post: 07-24-2015, 08:12 AM