Posts by DrRandyman

I have successfully figured out the problem for this worksheet. Thank you.

Hello,

I hope I am posting this in the correct forum. I have an Excel problem that, I'm sure, is quite simple for anyone in this forum, but for some reason, I am not sure of how to do this. Here is what is on the attached sheet:

Column A2:A6 - list of accounts we need to keep track of the funds.

Column B2:B6 - The amount that is in each account. This amount will not be touched, so they will be locked cells.

C1 is the sum of B2:B6.

Now, here is my problem. I want to be able to input a dollar amount into Cells C2:C5 (next to their respective accounts), adding them to cells B2:B5, and at the same time adding them to the Grand total. Is there a formula to do this? Or maybe you have another way of doing it.

For example, if I input $45 to cell C2, I want that to be added to B2, and also to C1. This way either a negative or positive number will affect the sums.

Hello,

I have an Excel problem that, I'm sure, is quite simple for anyone in this forum, but for some reason, I am not sure of how to do this. Here is what is on the attached sheet:

Column A2:A6 - list of accounts we need to keep track of the funds.

Column B2:B6 - The amount that is in each account. This amount will not be touched, so they will be locked cells.

C1 is the sum of B2:B6.

Now, here is my problem. I want to be able to input a dollar amount into Cells C2:C5 (next to their respective accounts), adding them to cells B2:B5, and at the same time adding them to the Grand total.

For example, if I input $45 to cell C2, I want that to be added to B2, and also to C1.

Great! It worked. Thank you.

I put this into the sheet, typed in Kayla into B2, but nothing happened. Maybe I did something wrong. I've attached the workbook for you to see.

Hello,

I am working with a workbook that requires a macro to be run when a specific text is typed, but I am unable to figure out how to get this done. In the attached workbook, the only sheet being modified is "Kayla".

When you look at the macros in this sheet, you will see only one. When you run it, you will see the message box that I want to be displayed. The problem is, how do I run it when I type in the name Kayla into one of the cells B2:D4?

Thank you,

Randy

Thank you. I will look at this.

You said "you are not using Excel with a clean database method (flat file) ... but rather like a Word processor". I would like to use Excel properly. Can you discuss this further?

Thank you for this. I will need to look at this when I am more available.

Ok, I agree to a button being used. Can you install that please?

Yes, I agree to have a database. How would I do that?

A couple of modifications please.

1. How will the scheduler add new names when they join? For example, adding new people to the nursery list or childrens church.

2. If a person is on two lists (nursery and childrens church), they can't be on the same date. Can there be a way of alerting the scheduler if they make this mistake?

3. The first Sunday of the month is important to the church. We are a trying to make sure that the people don't work back to back first Sundays. Is it possible to alert the scheduler if they make this mistake?

Hello,

Sorry for the delay. As far as having several persons belonging simultaneously to several categories. We don't want to have the same person on the Nursery schedule and the Childrens church schedule for the same day. (For example, Amy Cooper can't be in Nursery and Childrens church on the same day.) For Childrens church, there is only one leader, always.

You also asked, "Do you need to have dynamically adjusted Validation Lists by day, which means that as soon as a Name is picked, it does disappear from the initial list?". It doesn't need to disappear from the list. It would make it easier for the scheduler, but it doesn't have to.

Hello,

If I understand correctly, you are asking if the colors are important. No, the colors are only for visual differentiation.

Here is the updated book.

Did you place a macro in the workbook? I got some kind of warning when I opened it for the first time.

I have removed the "Master schedule". That was what the scheduler was using to work with her data. I admit that it was mysterious.

Thank you for the feedback on merging cells. That will be helpful for future project.

Thank you for doing this. I am pleased with what I see.

There is one thing though. Amy Cooper is supposed to be on the list for both church and nursery. What can we do to help the scheduler to not double schedule Amy in both nursery and church on the same day?

Wow! I am pleased at what you have done. Thank you for answering all of my questions also.

Here is the saved worksheet.

First of all, this looks amazing! You have clearly put a lot of effort into this workbook. I can only hope to someday understand Excel as well as you do.

A couple of questions though.

1. On the "Days off" sheet, what is the purpose of column C? I can see that it changes depending on the contents of E2.

2. You said, "you could add in Columns A and B the dates and names of the persons who will be off." Does this mean we can add to column A and B to accommodate for subsequent Sundays going into 2024?

3. Because of columns G,H, and I, it looks like I can delete the "Data validation" sheet. Is that correct?

4. Using Amy and Rosi in Childrens church, I'm noticing that if I put them in on May 7, there isn't anything telling me that a mistake has been made. Is there a way of alerting me (or the scheduler) of the problem other than going to the "Days off" sheet?

5. On the "Nursery" sheet, there isn't a drop down for column C.

All around, this is tremendously put together.

Thank you so much,

Randy

Thank you for all this work. I will not have time today to look at it, but I will be back in touch.