Data Validation - One List - hyperlinked somehow?

ginauk84

New Member
Joined
Aug 1, 2005
Messages
32
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.
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

listerheb

Active Member
Joined
Aug 22, 2003
Messages
262
Highlight your list, then in the name box, which is usually on the upper left under the save icon. It should say AA1 in it after you have highlighted the list you said. Click in there and type a name for the list. When you go to Data/Validation and allow List, Instead of puting the range of cells in there, put the name of the list.

That should do it for you.
 

ginauk84

New Member
Joined
Aug 1, 2005
Messages
32
Fantastic, that works fab. Is it possible to create the list in a new workbook and link several workbook lists to the master workbook?
 

Forum statistics

Threads
1,144,698
Messages
5,725,821
Members
422,643
Latest member
elwayfan446

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top