Is it possible to create a list in one place instead of on each worksheet? So that when you add in a new item for the list it updates every sheet automatically instead of having to go into every sheet?
Does in need to be in the same workbook or can you link from another workbook.
I am creating my list in AA1:AA10 and then putting this into data Validation: List. But we are updating the lists all the time and fed up of having to go into every single worksheet to update, it would be so much easier if we could have one list for them all.
Thanks.
Does in need to be in the same workbook or can you link from another workbook.
I am creating my list in AA1:AA10 and then putting this into data Validation: List. But we are updating the lists all the time and fed up of having to go into every single worksheet to update, it would be so much easier if we could have one list for them all.
Thanks.