Hi,
I have searched the forums and net, but cannot get an answer. I am looking for a formula that will make a cell keep the last formula result unless it is changed. I am currently using:
=IF(A6<>'Daily Input'!$B$4,M6,IF(A6='Daily Input'!$B$4,'Daily Input'!$C$8,M6)), but it is not working as effectively as i would prefer.
The idea behind this is data capturing, where the data is inserted according to the date specified by the user. If the date is changed, the data for the previous date musn't change but actually hold the information and the next date must be used. i know a macro doing paste special can be used, but I would prefer a formula to do this.
Please help
I have searched the forums and net, but cannot get an answer. I am looking for a formula that will make a cell keep the last formula result unless it is changed. I am currently using:
=IF(A6<>'Daily Input'!$B$4,M6,IF(A6='Daily Input'!$B$4,'Daily Input'!$C$8,M6)), but it is not working as effectively as i would prefer.
The idea behind this is data capturing, where the data is inserted according to the date specified by the user. If the date is changed, the data for the previous date musn't change but actually hold the information and the next date must be used. i know a macro doing paste special can be used, but I would prefer a formula to do this.
Please help
