Change the cell value based on changing date

SAPkannan@gmail.com

Guest

Posts: n/a

19th Nov 2007

I want to change the cell value automatically on daily basis based on
the change in date. for eg.

A1 = Opening balance
A2 = Deposit
A3 = Transaction
A4 = Closing balance

when the next day comes the opening balance should change as previous
day's closing balance.

Please help me in writing code for this.

Thanks in advance.

Kannan

« database formats | Set range to value from another sheet »

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
Automatically change cell colors based on date in cell	Greg	Microsoft Excel Misc	1	27th Jan 2009 05:53 PM
Changing values in cell based on system date	vignesh4you2mail@gmail.com	Microsoft Excel Worksheet Functions	2	24th Oct 2008 07:33 AM
How can I increase the value in a cell based on the changing date	=?Utf-8?B?Q3JheV96Nzc=?=	Microsoft Excel Worksheet Functions	5	13th Aug 2007 04:59 PM
Changing a cell color based on date entry ...	T. Denford	Microsoft Excel Programming	6	14th Apr 2005 12:16 AM
Changing a cell color automatically based on a date	Todd Michaels	Microsoft Excel Misc	2	10th Feb 2004 06:10 PM