Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 31st 07, 11:34 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 3
Default insert data based on time

I want to auto insert data based on date so that if A5 = Today then AF10 is
updated and the next day if A11=Today then AF11 is updated...... Using
formula in cell =IF(AF5=TODAY(),($B$10),"") but of course that doesn't work
because you have to go and delete the formula to make it static ---- any
suggestions please. Do I need a macro or is there someway of auto locking the
data once it has been updated.

  #2   Report Post  
Old March 31st 07, 12:24 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 1
Default insert data based on time



"BrianMcC" wrote:

I want to auto insert data based on date so that if A5 = Today then AF10 is
updated and the next day if A11=Today then AF11 is updated...... Using
formula in cell =IF(AF5=TODAY(),($B$10),"") but of course that doesn't work
because you have to go and delete the formula to make it static ---- any
suggestions please. Do I need a macro or is there someway of auto locking the
data once it has been updated.


If I understand your question correctly, all you need to do is to change
your equality test into a less than or equal test:
=IF(A1<=TODAY(),"Today or earlier","Not there yet")
will read "Today or earlier" if the date in A1 has been reached or passed,
but "Not there yet" if the date is in the future.
If you need different actions depending on past, present, or future you can
nest IF()s:
=IF(A1<=TODAY(),IF(A1<TODAY(),"Been there","Right now"),"Not there yet")

  #3   Report Post  
Old March 31st 07, 02:02 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 3
Default insert data based on time



"Malcolm Harper" wrote:

Its always the simple idea that you can't see. I missed that one. Many thanks for your help. Thats it sorted I think.

"BrianMcC" wrote:

I want to auto insert data based on date so that if A5 = Today then AF10 is
updated and the next day if A11=Today then AF11 is updated...... Using
formula in cell =IF(AF5=TODAY(),($B$10),"") but of course that doesn't work
because you have to go and delete the formula to make it static ---- any
suggestions please. Do I need a macro or is there someway of auto locking the
data once it has been updated.


If I understand your question correctly, all you need to do is to change
your equality test into a less than or equal test:
=IF(A1<=TODAY(),"Today or earlier","Not there yet")
will read "Today or earlier" if the date in A1 has been reached or passed,
but "Not there yet" if the date is in the future.
If you need different actions depending on past, present, or future you can
nest IF()s:
=IF(A1<=TODAY(),IF(A1<TODAY(),"Been there","Right now"),"Not there yet")



Reply
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
IF statement for time based data Daren Excel Worksheet Functions 13 October 22nd 06 04:19 AM
Recording Time & Date based on data input Lady Success Excel Worksheet Functions 2 October 19th 06 01:51 PM
Creating function to insert data based on criteria Tami Excel Worksheet Functions 1 August 18th 06 10:42 PM
can excel insert rown based on variable data in a cell? SSBG Excel Worksheet Functions 1 August 6th 06 01:30 PM
Using an IF statement on time based data DonB Excel Discussion (Misc queries) 11 December 3rd 05 04:07 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017