I am having to use Excel (2016) in order to resolve the following . Acces would be so much easier but the office will not use access
I have a tab of data where I need to
1, filter one column of data and then select each unique item in turn revealing the dataset and then save that dataset as a file, in all there will be about 60 files to save - basically the filter is looking at data per country and then each file would be sent to the person looking after that country. realise =this is not te best approach and Acces could do everything inc automated e-mail but I am dictated to be others
The running of the filter and saving process needs to run off a single macro Also the list of countries is variable in the dropdown list going forward
Can some suggest best Excel approach
PS to keep it simple the name of each file could be the filter value
I have a tab of data where I need to
1, filter one column of data and then select each unique item in turn revealing the dataset and then save that dataset as a file, in all there will be about 60 files to save - basically the filter is looking at data per country and then each file would be sent to the person looking after that country. realise =this is not te best approach and Acces could do everything inc automated e-mail but I am dictated to be others
The running of the filter and saving process needs to run off a single macro Also the list of countries is variable in the dropdown list going forward
Can some suggest best Excel approach
PS to keep it simple the name of each file could be the filter value