Bypas Nil Values
the data in the computed column on sales completed is something like this.
the data is dynamic and changes as each transaction is added to the workshet.
i need a macro which will, starting from anywhere on the worksheet take the
cursor to the cell with the last positive value i.e. 800,000
Trades Completed
0
200,000
1,000
1,000,000
0
0
0
0
800,000
0
0
0
|