I am trying to build new excel files from a master excel file based on a column filter. Can anyone suggest the best way to do it? Just for information, I have to create up to 70 new files based on location column, Also is there a way to include dynamic names for the new files created ? I have to save a copy for every day for every location.
Thanks in Advance,