Advanced list facility (Excel or VBA)

Hi,

I have included some list filters in an excel document (using advanced filters) to restrict what can be typed into my file. However the file is huge despite only having filters and no data.

Is there an alternate way - perhaps by VBA - to include this option of lists.

Using VBA, the ideal is that the person can use drop down boxes to pick customers etc and this populates a row - they should then be able to update other boxes in the same row manually.

Obviously when they go to the next row, they should have the same pop up box....but now amending the new row.

Is this possible?

Thanks!