What would be the formula to rather than referencing a cell but make it
go on the line below. For example:

The list below is the items available to order:
Chair 1 $100
Table 0 $0
PC 2 $500

Below is the final out come as it currently stands:

Chair 1 $100

PC 2 $500

I do not want the empty line between the two items. I need the PC to go
directly under the Chairs.

Thanks once again!


--
Anupkumar
------------------------------------------------------------------------
Anupkumar's Profile: http://www.excelforum.com/member.php...o&userid=35152
View this thread: http://www.excelforum.com/showthread...hreadid=549173