Sheet1 where your list is:

A B
1 words 6
2 words -4
3 words 2.1
4 words .01

Sheet2 where you want to echo data when a value is entered into column B on
Sheet1:
on Sheet2 in A1 enter:
=IF(Sheet3!$B1<0,Sheet3!A1,"")
and on sheet 2 in B1 enter:
=IF(Sheet3!$B1<0,Sheet3!B1,"")

continue that format out across row 1 to account for all cells in the row to
be echoed, then extend the group down the page to the end of the data rows.

Now, this is going to leave empty rows where no value is entered into column
B on the source list sheet, Sheet1. You can use Data | Auto Filter and
select [Non Blanks] to bring them all together on the second sheet.


" wrote:

I have a readymade list on sheet one. I need to enter figures
corresponding to only to some of the items in that list. Depending upon
the items for which i have entered figures, I would like to have only
those items and the corresponding figures appearing on the second sheet.