Sounds like I would be better off if I could try to always enter band name and have the other cells auto-populate from that information?
Yes. But can't a band have more than one song?