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
