+ Reply to Thread
Results 1 to 11 of 11

Auto updated chart

Hybrid View

taleksak Auto updated chart 10-01-2007, 01:57 PM
oldchippy Does this link offer any... 10-01-2007, 05:24 PM
taleksak Thanks but this didn't help.... 10-03-2007, 05:21 PM
oldchippy Do you mean something like... 10-04-2007, 06:23 AM
taleksak I want A23 to be totaly... 10-05-2007, 05:51 AM
oldchippy I would say the only way to... 10-05-2007, 05:54 AM
VBA Noob See if this works. Right... 10-05-2007, 06:09 AM
taleksak I couldn't make the visual... 10-07-2007, 05:45 AM
VBA Noob See attached example plus... 10-07-2007, 06:18 AM
taleksak No sorry, not that either...... 10-04-2007, 08:28 AM
oldchippy OK, so you want A23 to remain... 10-05-2007, 05:23 AM
  1. 10-04-2007, 08:28 AM #1
    taleksak is offline
    Registered User
    Join Date
    10-01-2007
    Posts
    7
    No sorry, not that either...

    I know it is the wrong fx, but just to illustrate:
    =IF(K22=VALUE("23/10/2007");A23;(""))
    My goal is to make A23 say "23/10/2007" when K22's value is "23/10/2007", but without writing any fx into A23. Cell A23 should stay totaly empty until the 23/10/2007

    thanks so far :-)
    Reply With QuoteRegister To Reply
  2. 10-05-2007, 05:23 AM #2
    oldchippy is offline
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    OK, so you want A23 to remain blank until 23/10/2007?

    How about this in A23

    =IF(K22=TODAY(),K22,"") then when A23 gets to 23/10/2007, then it will display in A23, before or after that date it displays blank

    or if you want A23 to display even after 23/10/2007, then you could use this

    =IF(K22<=TODAY(),K22,"")
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1