Displaying info in a new tab in excel

How do i get excel 2003 to display only certain information in another tab
automatically when a value is entered

Can you be a bit more specific? Examples?

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Khamul" <[email protected]> wrote in message
news:[email protected]...
> How do i get excel 2003 to display only certain information in another tab
> automatically when a value is entered

I have a program the automaticaly calculates cost of furnishing a house when
certain furniture is selected. I also have a lot of extra information in
that in that table i don't need to be printed so i want to have it display
only the items that were selected to display in a different tab or when the
sheet is printed it only prints certain cells with out having to select them.
that enough info?

Look at

http://www.cpearson.com/excel/noblanks.htm

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Khamul" <[email protected]> wrote in message
news:[email protected]...
>I have a program the automaticaly calculates cost of furnishing a house
>when
> certain furniture is selected. I also have a lot of extra information in
> that in that table i don't need to be printed so i want to have it display
> only the items that were selected to display in a different tab or when
> the
> sheet is printed it only prints certain cells with out having to select
> them.
> that enough info?

i have no idea how this formula work nor can i get it to work in my worksheets

"Niek Otten" wrote:

> Look at
>
> http://www.cpearson.com/excel/noblanks.htm
>
> --
> Kind regards,
>
> Niek Otten
>
> Microsoft MVP - Excel
>
> "Khamul" <[email protected]> wrote in message
> news:[email protected]...
> >I have a program the automaticaly calculates cost of furnishing a house
> >when
> > certain furniture is selected. I also have a lot of extra information in
> > that in that table i don't need to be printed so i want to have it display
> > only the items that were selected to display in a different tab or when
> > the
> > sheet is printed it only prints certain cells with out having to select
> > them.
> > that enough info?
>
>
>