I have a worksheet for my wife that she needs to fill out weekly for work. It contains 3 cells that I want to automate. My problem is that some of the date required changes at times. I will explain.

One cell needs this.. (Daily Goal Quota) = "Remaining monthly goal ÷ # of days left in the month."

The remaining monthly goal is derived by subtracting a changeable goal - what she has done to date which is in another cell already. She gets this from a printout. So the changeable goal needs to be input into this formula as a question.

Another cell needs.."Daily Goal Quota x days in that week"

The Daily Goal Quota is now a known from above but the days left in the week changes hence a question in the formula.

So my question is.. Is it possible to add a question to a formula? Like when she gets to the cell a pop up, or something, comes onscreen and asks her for the quota or days left in the week as needed.

I hope I've made this understandable. Thank you for your help.

One cell needs this.. (Daily Goal Quota) = "Remaining monthly goal ÷ # of days left in the month."

The remaining monthly goal is derived by subtracting a changeable goal - what she has done to date which is in another cell already. She gets this from a printout. So the changeable goal needs to be input into this formula as a question.

Another cell needs.."Daily Goal Quota x days in that week"

The Daily Goal Quota is now a known from above but the days left in the week changes hence a question in the formula.

So my question is.. Is it possible to add a question to a formula? Like when she gets to the cell a pop up, or something, comes onscreen and asks her for the quota or days left in the week as needed.

I hope I've made this understandable. Thank you for your help.

Last edited: