Spent several hours trying to find a fix...and came up blank

[Rowanze]

To be fair, I will start by saying I am very tech savvy but my coding skills are quite limited. As you can see from my attachment, I managed to code some basic things into my spreadsheet, but now I have a very specific need and I am stuck. I provided a copy of the work in progress spreadsheet, and maybe someone can help me fix it. I have a spreadsheet with 26 "sheets", one for each letter of the alphabet. This sheet is for use in a doctors offices, for tracking time spent on the phone with patients. We will be slowly signing them up for a program which requires tracking of this time. As you can see from the sheets, we will enter their name on the sheet corresponding to their last name. For instance, Smith goes on the S sheet. As Mr smith calls over and over we will track that time, and the spreadsheet will calculate the total time by adding up the entries in real time. What I am trying to do is make a Sheet 27, called Master, that will populate the names and total times as a master list.

I have ~25 entries set up for each letter, but we will likely only fill a few of those and not for every letter. I want to create an active and dynamic list on the Master Sheet. When I add Mr Smith on the S Sheet, I want his name to appear on the Master list. When I add Mr Jones on the J list, I want him to appear on the Master list. Is there a way to do this?

Thanks so much in advance.

[teylyn]

Hello,

your data architecture is the wrong way around. Do all data entry on one sheet. Then build a report on another sheet where you can filter by letter or by name. Two sheets. No code.

cheers, teylyn

[Rowanze]

Hello,

your data architecture is the wrong way around. Do all data entry on one sheet. Then build a report on another sheet where you can filter by letter or by name. Two sheets. No code.

cheers, teylyn

I thought about that, but in the future, when we have 400+ people signed up, I thought it might be easier and faster to find names in a fashion similar to one's contact list on their phone. I.E. by letter. I tried making one giant list when I first started but I could not figure out how to sort and preserve my structured data blocks (ie each patient has a data block that's 5 wide by 7 long cell). If I could solve that then maybe I could go back to the one giant list idea.

[Richard Buttrey]

Hi and welcome to the forum. Unfortunately your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)