Enter smallest amount in row
 

Hello:

I would like to have a code that enters the smallest number on a row to the
rest of the row. So lets say I use the range from A1 to H10. I want that for
row 1 if it has in A1 the value 253 and in B1 the value 219 and in C1 the
value 198, so the rest of that row (until H1) should have the value 198. And
when I'll enter the value 153 in D1, then all the rest after D1 should update
to 153 and so on. This should occur in each row in the range.

I usually enter the amounts from left to right in the range.

I need the Min in the whole list starting from A1 to
H10. So when I start, and the whole chart is empty all values are zero. Then
when I enter the first amount in A1 (lets say 10), then the whole row should
be the same since it is the lowest in the row (other than zero). Then when I
enter the next number in B1 (lest say 8), then the rest of the cells from C1
to H1 should have the 8. And when I enter a smaller amount in c1 the rest of
the row should lower as well. This can't be done with a formaula, as the
formula would get ereased when I enter an amount in that cell.

The same should happen when I delete one amount, then thwe whole row should
update with the smallest amount of that row, including the cell that was just
deleted.


Thanks for any help.

Art

Enter smallest amount in row
 

Responded to your other post.

If this post helps click Yes
---------------
Jacob Skaria


"art" wrote:

Hello:

I would like to have a code that enters the smallest number on a row to the
rest of the row. So lets say I use the range from A1 to H10. I want that for
row 1 if it has in A1 the value 253 and in B1 the value 219 and in C1 the
value 198, so the rest of that row (until H1) should have the value 198. And
when I'll enter the value 153 in D1, then all the rest after D1 should update
to 153 and so on. This should occur in each row in the range.

I usually enter the amounts from left to right in the range.

I need the Min in the whole list starting from A1 to
H10. So when I start, and the whole chart is empty all values are zero. Then
when I enter the first amount in A1 (lets say 10), then the whole row should
be the same since it is the lowest in the row (other than zero). Then when I
enter the next number in B1 (lest say 8), then the rest of the cells from C1
to H1 should have the 8. And when I enter a smaller amount in c1 the rest of
the row should lower as well. This can't be done with a formaula, as the
formula would get ereased when I enter an amount in that cell.

The same should happen when I delete one amount, then thwe whole row should
update with the smallest amount of that row, including the cell that was just
deleted.


Thanks for any help.

Art