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?

Products.XLSX

DanielG

@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/986838#M3250