How do I create a macro including if statement & automatically

I need to create a worksheet where I can have a list of various data and if
I change the value of one row and that is of a higher value than any other in
this list , I need this row to jump to the top of the worksheet.

This should then happen automatically, ie every time you enter a sum in the
value column it should perform the if statetment automatically and check
wether the top value cell has got a higher value than the sum I just typed in.

Anyone got any ideas of how to do this?

Personally, this would drive me batty. If I make a change, it could go anywhere
in the list. If I make a typing error, I may not be able to find it (easily).

Instead of making it automatic, I'd just plop a button from the forms toolbar on
that sheet. I could record a macro that would sort exactly the way I want and
assign that macro to that forms button.

Then I do the data entry (and verification) and click that button only when I'm
happy.



betatryck_se wrote:

How do I create a macro including if statement & automatically

I need to create a worksheet where I can have a list of various data and if
I change the value of one row and that is of a higher value than any other in
this list , I need this row to jump to the top of the worksheet.

This should then happen automatically, ie every time you enter a sum in the
value column it should perform the if statetment automatically and check
wether the top value cell has got a higher value than the sum I just typed in.

Anyone got any ideas of how to do this?

--

Dave Peterson

You are right it is not a very good way of doing thing but its somebody at
work who "needs" this function. I will try making it the way you described it
and see if it could work for them.

"Dave Peterson" skrev:

Personally, this would drive me batty. If I make a change, it could go anywhere
in the list. If I make a typing error, I may not be able to find it (easily).

Instead of making it automatic, I'd just plop a button from the forms toolbar on
that sheet. I could record a macro that would sort exactly the way I want and
assign that macro to that forms button.

Then I do the data entry (and verification) and click that button only when I'm
happy.



betatryck_se wrote:

How do I create a macro including if statement & automatically

I need to create a worksheet where I can have a list of various data and if
I change the value of one row and that is of a higher value than any other in
this list , I need this row to jump to the top of the worksheet.

This should then happen automatically, ie every time you enter a sum in the
value column it should perform the if statetment automatically and check
wether the top value cell has got a higher value than the sum I just typed in.

Anyone got any ideas of how to do this?

--

Dave Peterson