R
Ron Bernstein
I have a workbook which is updated with test data each
day. There is a summary tab in the workbook which
summarizes the data on a daily basis.
I read the summary sheet from my worksheet. I have a row
to correspond with each day's worth of data. I am using
the following formula to update the cell:
=IF(A36 = TODAY( ), $D$26, #N/A). $D$26 would be the
location where I am reading the new data from the other
work book. I open my work book once each day to get the
new data from the other EXCEL file.
I want to know what I need to do with the formula above so
that if it is not today, I do not lose my data. In each
row that I have the formula, if the date on the row is not
today, I am not retaining the data, since the "IF"
statement is false.
I would appreciate any recommendations.
day. There is a summary tab in the workbook which
summarizes the data on a daily basis.
I read the summary sheet from my worksheet. I have a row
to correspond with each day's worth of data. I am using
the following formula to update the cell:
=IF(A36 = TODAY( ), $D$26, #N/A). $D$26 would be the
location where I am reading the new data from the other
work book. I open my work book once each day to get the
new data from the other EXCEL file.
I want to know what I need to do with the formula above so
that if it is not today, I do not lose my data. In each
row that I have the formula, if the date on the row is not
today, I am not retaining the data, since the "IF"
statement is false.
I would appreciate any recommendations.