q: dropdown list

J

JIM.H.

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
 
L

Leung

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
 
Top