RE: Dynamically changing the size of a list

From: Ed <Ed_at_discussions.microsoft.com>
Date: Fri, 30 Jun 2006 20:47:01 -0700

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 Received on Fri Jun 30 2006 - 20:47:01 PDT