Forum Discussion
Repeat a cell value each month
I'm trying to build a budget ongoing cash flow, so I have an amount going out each month on a particular day. I would like to put in the amount and for that to repeat on the 3rd of each month.
My cells on the left have Provider-Amount-repeat day, Accpros the top I have the date.
Any help would be appreciated.
| 06/08/2024 | 07/08/2024 | |
| Day in Month | Tuesday | |
| Balance | -£4.79 | |
| ü | ||
| Gym | £10.00 | 3 |
You have had close to 50 views without a reply. I suspect that may be due to the fact that your example is hard to make sense of. For example:
- Day in Month: Tuesday? There are typically several Tuesdays in any given month, not just one. What are we to make of that entry?
- What is the ü in the row under the "balance"?
- What does the 3 in the final cell represent?
Do you have a more complete spreadsheet started yet? Could you share it on OneDrive, GoogleDrive or some equivalent? Just give us a link here that grants access. My suspicion is that there may be a better design that would help, but we need to see where you're going with more sample entries.
- Sorry, Day in Month: Tuesday? There are typically several Tuesdays in any given month, not just one. I need the day to be taken from the date in the above cell.
The day What are we to make of that entry? The day "Tuesday" is just for my use.
What is the ü in the row under the "balance"? On my Spreadsheet it is a tick symbol.
What does the 3 in the final cell represent? 3 is the day that the debit is collected each month.
I'm sorry my explanation was so poor.OK. You a;nswered my questions. I also had a request.
Do you have a more complete spreadsheet started yet? Could you share it on OneDrive, GoogleDrive or some equivalent? Just give us a link here that grants access. My suspicion is that there may be a better design that would help, but we need to see where you're going with more sample entries.
