hello, hoping someone can solve my problem here.
i have 3 cells per page that are retrieving a max time value from another cell basedon a 3 other trigger cells in each sheet.. the triggers work and the cells get their value from the maxtime value cell. but when the 2nd or 3rd trigger cell values are true ALL the cells are reupdating their times.
basically it says IF L4 <> "" then BJ4 = BM46
and the same for
IF L16 <> "" then BJ16 = BM46
and again
if L28 <> "" then BJ28 = BM46
the target cells are grabbing the Bm46 values but as bm46 is updated over and over again the target cells in column BJ are also constantly updated. How can i make the cells keep their Initial values without locking the sheet as there are many many entries on each sheet a user constantly need access to use.
any help would be greatly appreciated
i have 3 cells per page that are retrieving a max time value from another cell basedon a 3 other trigger cells in each sheet.. the triggers work and the cells get their value from the maxtime value cell. but when the 2nd or 3rd trigger cell values are true ALL the cells are reupdating their times.
basically it says IF L4 <> "" then BJ4 = BM46
and the same for
IF L16 <> "" then BJ16 = BM46
and again
if L28 <> "" then BJ28 = BM46
the target cells are grabbing the Bm46 values but as bm46 is updated over and over again the target cells in column BJ are also constantly updated. How can i make the cells keep their Initial values without locking the sheet as there are many many entries on each sheet a user constantly need access to use.
any help would be greatly appreciated