Autosorting of Data

I want to input values in a particular cell, say in C4, and there are 30 data that I will input in this cell. And each value will be registered to cell range G2:G31 BUT with the values sorted automatically in descending order as I input each value. Are there any functions that will do this or a Macro perhaps? Please help..thanks

How is the value "registered" from C4 into G2:G31? Through a button or on worksheet change event?

By simply pressing enter. For example if I input 5 to C4 and then press Enter, then G2=5. If my next data is 10, then G2=10 and G3=5 (descending order). If the next data is 3, then G4=3. and so on...Each data should be inputted in cell C4

Try the attached.

yeah that's exactly what I wanted..Thanks a lot Sir...