Hello guys,

maybe there is an easy solution but i didnt find it yet. I want to put an Command Button into an Excel sheet that can do the following:
Based on a calculated value in another Cell this button should as a result generate in the same sheet a list of different documents that are lying on a server

Based on the value these documents can be different.

As exmample
The Calculated Value is 1 so you click the button and the list will contain 5 documents, or at least the path to these docs
The Value is 2 then there are 7 Documents to show in this list.

Is something like this possible or am i on the wrong path.

Any idea is much appreciated.

Have a nice day
Dieter