Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Updates With Date
Dear All,
I'm currently managing a database, and am trying to plot a graph from a set of values. These Values update based on the date from another worksheet, vua the formula =IF(($K$5=TODAY()),'Data File'!$G$14,J7) This means that the Data will update each day, and if it isnt today, then it will take the values from the previous cells. However, seeing as I am trying to collect the values over a period of time, showing their change etc, the values will not be kept in the assigned cells when the date changes. As such, unless it is today, all the figures will be the same for the previously recorded days. Is there anyway of telling Excel, through a formula, that if it is today, update the information in the allocated cells from the data in a certain worksheet. If it is not, then keep the values it previously had. When the date changes (say in a week) keep the updated values in those cells (Basically lock the values in the cells as soon as they are updated in accordance with the date!!). I apologise for the complexity of the query, but it is somewhat hard to explain!! Thankyou in Advance B |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Updates With Date
No. Formulas are "live". To get things to happen once only - that is, tied
to an "event" - you need a macro. "Boxer" wrote in message ... Dear All, I'm currently managing a database, and am trying to plot a graph from a set of values. These Values update based on the date from another worksheet, vua the formula =IF(($K$5=TODAY()),'Data File'!$G$14,J7) This means that the Data will update each day, and if it isnt today, then it will take the values from the previous cells. However, seeing as I am trying to collect the values over a period of time, showing their change etc, the values will not be kept in the assigned cells when the date changes. As such, unless it is today, all the figures will be the same for the previously recorded days. Is there anyway of telling Excel, through a formula, that if it is today, update the information in the allocated cells from the data in a certain worksheet. If it is not, then keep the values it previously had. When the date changes (say in a week) keep the updated values in those cells (Basically lock the values in the cells as soon as they are updated in accordance with the date!!). I apologise for the complexity of the query, but it is somewhat hard to explain!! Thankyou in Advance B |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My chart automatically updates, but how can i keep it within a static date range???? | Charts and Charting in Excel | |||
Date function in Excel that updates only when a doc is changed? | Excel Worksheet Functions | |||
date that updates itself daily, plus another formula please?? | Excel Worksheet Functions | |||
Is there a way to automatically add columns as the data updates? | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |