Looping macro
 

Hi
I've got no Idea how to start this Idea. I want to make a macro that
does this.

It would read a total of a calculation at the bottom of a page. If its
0 then the Macro will get that figure and insert it into the cell
that has the start figure.

eg. If total is 0, then replace opening balance with total. If total
is < 0 then stop.


When it does stop then it finds the first negitive number down a colum
and say in F and reports the date in colum B.

Imagin you are looking at a bank loan statement.


--
furanku
------------------------------------------------------------------------
furanku's Profile: http://www.excelforum.com/member.php...o&userid=27529
View this thread: http://www.excelforum.com/showthread...hreadid=470503

Looping macro
 

Check out the Goal Seek utility available through the Tools menu.

Regards,
Greg

"furanku" wrote:


Hi
I've got no Idea how to start this Idea. I want to make a macro that
does this.

It would read a total of a calculation at the bottom of a page. If its
0 then the Macro will get that figure and insert it into the cell
that has the start figure.

eg. If total is 0, then replace opening balance with total. If total
is < 0 then stop.


When it does stop then it finds the first negitive number down a colum
and say in F and reports the date in colum B.

Imagin you are looking at a bank loan statement.


--
furanku
------------------------------------------------------------------------
furanku's Profile: http://www.excelforum.com/member.php...o&userid=27529
View this thread: http://www.excelforum.com/showthread...hreadid=470503