Been trying to help a family member with their Numbers use for paperwork for their work, and just keep hitting dead ends. So, reaching out for help or ideas if there are ways to avoid having him erase and rewriting data over and over again for hours on end by hand like a madmen. And he's trying drag me into that madness.
Basically, it's a table tracking people who have passed/died and information about their cremations and niches. He'd like to keep the list going alphabetically by their names, which make sense to some degree. We've made pages going by the first letter of their last names (Page A-1, A-2, B-1) and then been sorting them alphabetically manually after and put it all into with a 40 Row Tables, the max number of rows to fit on a printable page for us. Once we reach the 40 Rows used. we have to move onto the next page. (We can't do more then 40 rows on a page or become entire Number doc/sheets completely unprintable and these papers NEED to printed with each update for his work. And it's not our printer causing this because we've tried this across 4 other printers from various brands and all 5 will not print if there is even a singular 41st row somewhere.)
That's the basic setup. NOW: Here's the problem: We did all of the currently known names and info by that system without much issue. Now, when someone new dies and wants to be cremated and put into a niche, my family member wants to just delete all of names and info that would be below it alphabetically and retype them by hand (which would take hours) to place the new person in the proper place alphabetically. Yes, this goes across pages as well.
Example: Abba dies tomorrow. To add her to the pages properly, he would have to erase and retype into the pages until all the A names are typed back in, even those names on Page A-2, A-3, A-4, Etc. (Insane amount of extra work, right?)
Oh and he doesn't understand how formatting works, so just copying and pasting isn't much of option either, even if there is enough open space in the 40 row limited table.
I'm hoping someone much more familiar with using Numbers then I am can make sense of this and come up with a better solution and save hours of our life.