I have made a simple monthly table with two formulas per row, In which
one formula takes its calculation from the previous row. The trouble is
when I enter the information for row january, all the calculations for
the rest of the year are showing and the table looks a mess.

How do I only show the calculations for the rows that I have entered
information in only?

Hope someone can hope.


--
Jozmoz
------------------------------------------------------------------------
Jozmoz's Profile: http://www.excelforum.com/member.php...o&userid=33085
View this thread: http://www.excelforum.com/showthread...hreadid=528955

I think we need to see your formulae to help you here, and an explanation of
how the data is layed out.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jozmoz" wrote in
message ...

I have made a simple monthly table with two formulas per row, In which
one formula takes its calculation from the previous row. The trouble is
when I enter the information for row january, all the calculations for
the rest of the year are showing and the table looks a mess.

How do I only show the calculations for the rows that I have entered
information in only?

Hope someone can hope.


--
Jozmoz
------------------------------------------------------------------------
Jozmoz's Profile:
http://www.excelforum.com/member.php...o&userid=33085
View this thread: http://www.excelforum.com/showthread...hreadid=528955

Thanks for the reply.

If you would like to view my excel document go to:-

http://192.168.0.2/Private%20Mileage.xls

You can see march and aprils rows filled in but how do I hide the
calculations for the coming months until I get to those months.

Thanks again.


--
Jozmoz
------------------------------------------------------------------------
Jozmoz's Profile: http://www.excelforum.com/member.php...o&userid=33085
View this thread: http://www.excelforum.com/showthread...hreadid=528955