ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Auto-insert same value each Monday in cashflow worksheet? (https://www.excelbanter.com/excel-worksheet-functions/261405-auto-insert-same-value-each-monday-cashflow-worksheet.html)

Scribble

Auto-insert same value each Monday in cashflow worksheet?
 
This will seem like kindergarten to some of you...
While constructing an Excel worksheet as a simple cashflow aid, I would like
to tell the sheet that on each Monday, for example, when a category has no
value (0 in cell), a standard value should be inserted throughout the year.
eg Insert the same value every Monday against "income".
Also, can anyone direct me to a good list of formulae and some explanations
for a bear of little brain?


All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com