Hi,
Please help if possible.
Background: The file contains 2 sheets, one sheet to enter variables (eg fabric type, garment type etc) and the second sheet is to creat garment "recipes" using the data in the LIST sheet. The drop down lists are located in the PATTERNS sheet and refer to data in lists in the LIST sheet by means of data validation.
I don't know how I did it, but my drop down list, if located in Row 3, only shows list items 1 to 3 ; Row 4 shows list items 1 - 4, and so on. What have I done wrong and how to fix? I have tried re-entering into a new sheet but no luck. An additional problem here is that the lower the row in the PATTERNS sheet, the lower the default position within the drop down list itself. Hard to explain but if you click on each cell in Column A going downwards, you will see how the appearance of the list changes in each cell.
(There are 2 small macros in the workbook but I don't think you would need to enable them to answer my query. They are basically just to sort the data in the lists so I can use LOOKUP later.)
Thanks in advance!
UPDATE: Please note that the lower end of the list range is not locked as I need to add items to the list and still have them appear on the drop down. I am reasonably certain that this isn't the problem. But perhaps I am misunderstanding something.