B
bhoff23
Here's what I'm trying to do:
I need to track a group of people on how fast they run a 1.5 mile. Eac
time we do this, I want the user to select their time from a combo box
This part is no problem and is already underway. However each perso
has a sheet that I want to have each run time in as well so that yo
can look at the overall group times and then look at the indivdiual
progress seperatly.
I can get it so that the NEW values are placed in the rows that I want
but I can't figure out how to keep the old cells from changing. I'
like it so that they are only updated for the current date.
The only way I can think of doing this is to make a cell to hold th
old data, then do a validation test to replace the new data with th
old data if it was overwritten. Is there a way to use 'paste special
in an IF function? Or is there an automatic way to use 'paste special
outside of using VBA
I need to track a group of people on how fast they run a 1.5 mile. Eac
time we do this, I want the user to select their time from a combo box
This part is no problem and is already underway. However each perso
has a sheet that I want to have each run time in as well so that yo
can look at the overall group times and then look at the indivdiual
progress seperatly.
I can get it so that the NEW values are placed in the rows that I want
but I can't figure out how to keep the old cells from changing. I'
like it so that they are only updated for the current date.
The only way I can think of doing this is to make a cell to hold th
old data, then do a validation test to replace the new data with th
old data if it was overwritten. Is there a way to use 'paste special
in an IF function? Or is there an automatic way to use 'paste special
outside of using VBA