ARRAY i think
 

I have a column of data that i change periodically throughout the data. I
want to save the changes i make each time and paste them to a new location
where i can see every change i made throughout the day. I was thinking an
array? I also want to skip and blanks or cells that say value. Any ideas?

thanks,

Jase