Tag Archives: excel save each sheet as a separate xlsx file

Project: Split Countries into new file

The project brief was to create a macro on a button that would follow this process: Open dialog box so user can choose file to work with Identify which column is headed ‘Country’ Take each ‘Country’ by its value (UK, ES, USA etc) in the column and split them into their own file saved in […]

the web designer group uk
the webdesigner group logo

Close Button

Web Site Designed by

The Web Designer Group