Input/Output excel file with drop down list

[Luk88kk]

Hi everyone,

Could you please help to solve the issue.

I have an excel file that has a drop down list. My task is to split the file into 3 people. The files that these people receive should contain this drop down list. Is it possible to do this or will I have to manually add this list?

[DanielG · Accepted solution]

@Luk88kk - what I have done in the past in create a template excel file with any excel specific formatting, then use the Blob Input/Output to create copies of the template than you can then push your data into and save in another (or same) location with distinct names so the template remains unchanged. 

There are many writeups explaining what the Blob Tools are on the Community.  Here is one:  https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/bc-p/...

[Luk88kk]

Hello,

Thank you very much I will read these posts.