I have a worksheet that gets a date from another worksheet and displays it in a cell. I want it to only update if another cells value is "Y", If the cells value is "N", I want it to leave the displayed date the way it is and not update the date from the other sheet. I have used an "IF A1=Y(formula)" but it doesn't leave the exsisting date displayed. I don't want to use iterations either because that would affect the other formulas I think. Any suggestions gratefully accepted.
If you mean that you have a formula that have a date from another sheet and if the date of the other sheet changes you want the date of the formula cell only to change if another cell is Y? That won't work given the restrictions with regards to iterations etc.. -- Regards, Peo Sjoblom "Ricke" wrote in message news:8DBED8E7-CB46-48B6-9319-8AC0711FED9D@microsoft.com... >I have a worksheet that gets a date from another worksheet and displays it >in > a cell. > I want it to only update if another cells value is "Y", If the cells > value > is "N", I want it to leave the displayed date the way it is and not update > the date from the other sheet. I have used an "IF A1=Y(formula)" but it > doesn't leave the exsisting date displayed. I don't want to use iterations > either because that would affect the other formulas I think. > Any suggestions gratefully accepted.
That is exactly what I want The formula I am using in the cell 'C4' that displays the date is: =IF(B1="N",DATEVALUE('\\SCHEDS\[AvailableHours.xls]Sheet1'!C$2),C4) This seems to work by setting the iterations to '1' but I don't want to do it with the iterations. There are many people on the network that use this and it would depend on them setting thier options. Won't work. "Peo Sjoblom" wrote: > If you mean that you have a formula that have a date from another sheet and > if the date of the other sheet changes you want the date of the formula cell > only to change if another cell is Y? That won't work given the restrictions > with regards to iterations etc.. > > > -- > > > Regards, > > > Peo Sjoblom > > > > > > "Ricke" wrote in message > news:8DBED8E7-CB46-48B6-9319-8AC0711FED9D@microsoft.com... > >I have a worksheet that gets a date from another worksheet and displays it > >in > > a cell. > > I want it to only update if another cells value is "Y", If the cells > > value > > is "N", I want it to leave the displayed date the way it is and not update > > the date from the other sheet. I have used an "IF A1=Y(formula)" but it > > doesn't leave the exsisting date displayed. I don't want to use iterations > > either because that would affect the other formulas I think. > > Any suggestions gratefully accepted. > > >
Only other way would be a macro -- Regards, Peo Sjoblom "Ricke" wrote in message news:910AB4B4-A109-49A3-AC3D-079BF28B5C6A@microsoft.com... > That is exactly what I want > The formula I am using in the cell 'C4' that displays the date is: > =IF(B1="N",DATEVALUE('\\SCHEDS\[AvailableHours.xls]Sheet1'!C$2),C4) > > This seems to work by setting the iterations to '1' but I don't want to do > it with the iterations. There are many people on the network that use > this > and it would depend on them setting thier options. Won't work. > > > > > "Peo Sjoblom" wrote: > >> If you mean that you have a formula that have a date from another sheet >> and >> if the date of the other sheet changes you want the date of the formula >> cell >> only to change if another cell is Y? That won't work given the >> restrictions >> with regards to iterations etc.. >> >> >> -- >> >> >> Regards, >> >> >> Peo Sjoblom >> >> >> >> >> >> "Ricke" wrote in message >> news:8DBED8E7-CB46-48B6-9319-8AC0711FED9D@microsoft.com... >> >I have a worksheet that gets a date from another worksheet and displays >> >it >> >in >> > a cell. >> > I want it to only update if another cells value is "Y", If the cells >> > value >> > is "N", I want it to leave the displayed date the way it is and not >> > update >> > the date from the other sheet. I have used an "IF A1=Y(formula)" but >> > it >> > doesn't leave the exsisting date displayed. I don't want to use >> > iterations >> > either because that would affect the other formulas I think. >> > Any suggestions gratefully accepted. >> >> >>
How would I do that? "Peo Sjoblom" wrote: > Only other way would be a macro > > > -- > > > Regards, > > > Peo Sjoblom > > > > "Ricke" wrote in message > news:910AB4B4-A109-49A3-AC3D-079BF28B5C6A@microsoft.com... > > That is exactly what I want > > The formula I am using in the cell 'C4' that displays the date is: > > =IF(B1="N",DATEVALUE('\\SCHEDS\[AvailableHours.xls]Sheet1'!C$2),C4) > > > > This seems to work by setting the iterations to '1' but I don't want to do > > it with the iterations. There are many people on the network that use > > this > > and it would depend on them setting thier options. Won't work. > > > > > > > > > > "Peo Sjoblom" wrote: > > > >> If you mean that you have a formula that have a date from another sheet > >> and > >> if the date of the other sheet changes you want the date of the formula > >> cell > >> only to change if another cell is Y? That won't work given the > >> restrictions > >> with regards to iterations etc.. > >> > >> > >> -- > >> > >> > >> Regards, > >> > >> > >> Peo Sjoblom > >> > >> > >> > >> > >> > >> "Ricke" wrote in message > >> news:8DBED8E7-CB46-48B6-9319-8AC0711FED9D@microsoft.com... > >> >I have a worksheet that gets a date from another worksheet and displays > >> >it > >> >in > >> > a cell. > >> > I want it to only update if another cells value is "Y", If the cells > >> > value > >> > is "N", I want it to leave the displayed date the way it is and not > >> > update > >> > the date from the other sheet. I have used an "IF A1=Y(formula)" but > >> > it > >> > doesn't leave the exsisting date displayed. I don't want to use > >> > iterations > >> > either because that would affect the other formulas I think. > >> > Any suggestions gratefully accepted. > >> > >> > >> > > >
