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.

Hello, I did once a similar table and what I did was: (The table was a
supliers table) on Sheet 1 I made a huge table with "List" which kept growing
then I selected a column for example the "Suplier's Name", and gave it a
name, (Insert Name) then on Sheet 2 I made the form. I grouped horizontally
fields which would be likely to have information and those who don't. On the
"Suppliers Name" field I Used Data Validation to have a dropdown to select
the names and the rest of the fields populated through VLOOKUP.

Here comes what you were talking about. I had many fields and sometimes just
a couple of them had info and the form was almost empty, On the first column
i set a couple of IF formulas, to indicate that, when there is info on any of
the fields to the right give a "x" if not, then nothing "". So by selecting a
name from the suppliers list, i had a bunch of x's and blanks.

Then I used Autofilter to the header of the 1st column, and finally a Marcro
to filter each time I select a entry from the dropdown list, the column with
all the x's hidden and then I get a form that only shows what is filled
(sorry but just horizontally-wise, some fields might have nothing but in that
row other field had something).

HTH

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.