Jerry this is fabulous but I was wondering if you would help me to adapt the code as I've been unsuccessful. I need to use this method to do something nearly similiar. The Database Sheet remains but the user would select the column heading B-G from a drop down menu on another sheet and the items would populate on that SAME page in a range below it. Being new to the forum I'm not sure if I need to start a new thread. Thanks!