Hi, Thanks to help from this forum ive put together a niffty little excel form. However its quite large and by the time user add more and more items to the good list its gonna get a whole lot larger.
In my work book i refer to certain lists such as: users, suppliers, delivery address, payment type etc.... this is on one worksheet called Options. I have given each list a name and refer to these using the validation tool.
I want to create a different workbook called Lists, which contains the above data. Basically move the options worksheet to a new work book.
Could someone point me in the right direction as to how i could then refer to these lists in a different workbook and how i could possible add to each list form a user form within the original workbook.
Cheers
Manny