Auto-insert same value each Monday in cashflow worksheet?

Scribble

Guest

Posts: n/a

13th Apr 2010

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?

« Hyperlink won't open in excel | stock control template »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert row in Master worksheet that auto inserts in other workshee	mary p	Microsoft Excel Misc	2	16th Feb 2009 08:21 PM
Can I auto insert a worksheet when I insert a value in a cell.	=?Utf-8?B?aWFpbmM=?=	Microsoft Excel Worksheet Functions	0	27th Apr 2006 08:37 AM
auto insert copy of worksheet	=?Utf-8?B?Q2FybG9zIE11bm96?=	Microsoft Excel Programming	4	11th Mar 2004 07:31 PM
auto insert copy of worksheet	=?Utf-8?B?Q2FybG9zIE11bm96?=	Microsoft Excel Worksheet Functions	2	4th Mar 2004 05:01 PM
Auto insert worksheet from template	Isabelle	Microsoft Excel Worksheet Functions	0	17th Dec 2003 04:01 PM