dik
Structural
- Apr 13, 2001
- 26,025
As a follow up to linking spreadsheets...
Is it possible to link a dropdown list of the section types for different spreadsheets/data? I have currently created a new column using the original section designations that are sorted from biggest to smallest section. I have then sorted balance of the data in the sheet for VLOOKUP to work properly.
Alternatively is it possible to test a value and using the test result to load a different dropdown list?
Dik
Is it possible to link a dropdown list of the section types for different spreadsheets/data? I have currently created a new column using the original section designations that are sorted from biggest to smallest section. I have then sorted balance of the data in the sheet for VLOOKUP to work properly.
Alternatively is it possible to test a value and using the test result to load a different dropdown list?
Dik