finding next blank cells

[Bill McGuire]

I need to input numerical data into 10 cells (C1...C10). and have the
copied to a second sheet at say D1...D10. When I reenter differen
numbers on C1...C10, I need to have the new numbers placed in E1...E10
and continue in order down the second sheet page. This is probably a
easy task, but both my right and left sides of my brain seem to b
playing hide and seek or something. Thanks for the help..

 

[Myrna Larson]

This sounds like a sort of "audit trail". Do do this would require a VBA macro
code. It can't be done with formulas.