Excel Parameter from Drop down
I have a datasource that poplulates my sheet from sql server. There is a parameter to refresh the 开发者_StackOverflow中文版data. Can I have the choices come from a drop down menu on another sheet? I know no VBA BTW.
I know this is a old but the answer is No.
To add dynmic parameters, you need to use VBA.
Its not hard. Since this queistion is 4 months old you have probably already figured that out.
精彩评论