Thread: Direction of Data Movement Problem

Hi guys,

I need to know how can I change the settings in excel such that whenever I enter data the older data moves downward.

For Example: Consider a list of data such as data1,data2,data3,data4,...

What Excel offers is:
A B C D E
1 data1
2 data2
3 data3
4 data4

What I want is:

A B C D E
1 data4
2 data3
3 data2
4 data1


Kindly note that the manner of data entry will be firstly data1 then data2 and so on.

As u see what I want is for the previous data to move downwards as I am entering.

Hope u guys can help me out here.

Vijay