q: dropdown list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list in Column A in my Main.xls, I would like to see this list in a
dropdown list in another excel file. If I add one more item to this list all
the excel files should be refreshed. Is this possible? If
 
The drop down, data > valuation > list, works within the same sheet rather
than another Excel File.

So I think it's not possible.

To achieve this, i suggest you to put them together or you could use some
hide and protect feature for your spreadsheets.

Leung
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With MS Access 4
data validation, totaling values based off dropdown lists 5
Multi-select from a dropdown list 5
Displaying arrow in a dropdown list within cell 2
How can I use conditional formating in dropdown using named list? 1
Creating a dropdown list based on selection from a differernt drop 5
Combobox dropdown list??????????? 3
MULTIPLE ROW DROPDOWN LIST 4

Back
Top