LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Refreshing one cell

Hello,

I'm not too proficient with Excel so hopefully this can be done. My client
is using this formula to update the date and time in a particular cell:

=IF(A2="","",NOW())

He wants it to update only when A2 is updated, but it updates when any cell
is updated. Does this require a code and if so how to implement it.

Thank you for any help and God Bless,

Mark A. Sam


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cell range not changing when refreshing linked data- sumproduct fo lharp21 Excel Worksheet Functions 1 February 25th 10 10:56 PM
refreshing data in a pivot table changes cell format pistolpete Excel Discussion (Misc queries) 1 July 27th 09 05:52 PM
Update Excel cell in formula not refreshing answer cell Johnny Excel Discussion (Misc queries) 2 June 21st 07 05:49 AM
Non Refreshing/Recalculating Cell ?? J Excel Programming 2 May 22nd 06 09:46 AM
Refreshing drop down cell values... Dyce Excel Worksheet Functions 0 August 24th 05 10:49 PM


All times are GMT +1. The time now is 12:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"