how do I make a new spread sheet pop up, based on an entry in a c.
 

For example, I enter a "4" in a cell, then a 1x4 spread sheet pops up and the
results of the entry in the new spread sheet are shown in the adjacent cell
to where the "4" is.

see your later posting in this newsgroup under a different name.
If you change you name -- I'd think that might make it difficult to find
your own posted questions and the replies to them.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"jpryce" wrote in message ...
For example, I enter a "4" in a cell, then a 1x4 spread sheet pops up and the
results of the entry in the new spread sheet are shown in the adjacent cell
to where the "4" is.