Populate cell from another sheet based on the date (calc)

[rbarei07]

Hello!

I really love making spreadsheets and I am curious about whether the following is possible or not.

I have one sheet that is my personal monthly budget and another sheet that represents what is owed monthly by myself and my roommates. My budget varies, ergo, what I owe varies.

Is there a way to pull the data from my “total amount owed” cell and place it in the cell of what I owe but only do it on a specific day?

Example: I update my budget every five or six days, but every two weeks or a month I want the “total amount owed” cell from one sheet to be populated into the cell on the sheet for the house budget.

Is this possible or am I living in a fantasy world?

[Wanderer]

You wish to go the most complicated way… Showing always the current balance needs no conditions, and can be done by formula.

@rbarei07

place it in the cell of what I owe but only do it on a specific day?

This sounds more like “use copy-and-paste”, wich would call for macro. And if you can manage to use always the same two cells to be used as source and target I would just record a macro to do this. This puts the task to find out, if today is a “specific” day to the user before he/she calls the macro.

[rbarei07]

Yes, it is complicated. I’ll just copy and paste the cell once a month!