I need assistance with the following issue. I have a macro that helps me fill in some details within a blob template. The macro works more or less as intended. In my 'Example workflow', I would like to use the macro and also incorporate a directory containing multiple .xlsx files. I need to create a macro that will take the output of the blob macro and the path where the .xlsx files are saved, read them, and allow the user to select which sheet will eventually be appended to the blob file. I'm not sure how to do that since the output of the blob is already saved. I suppose I need to modify the initial blob macro, but I can't pinpoint what needs to be changed. I have attached a FinalOutputExemp.xlsx for reference for the final output representation.
Your use case is a chained app. select a file. Select a sheet = chained app. app 1) - select file. get list of sheet names. 2) app 2 - populate drop down from sheetnames of app 1 - generate drop down - update blob/template.
