I have a spreadsheet, that has been created, and the cells are unlikely to move location, so would now like to impose a macro onto it.
It is a master sheet, and I need it broken into tabbed sheets, whenever there is a change in both the CUSTOMER NAME and COUNTRY. I wish to keep the master sheet at the front of the list.
I have created an example of the cells, and stripped out any irrelevant data; keeping only the Customer Name and Country in.
Please view the sheet attached: all data.xls
This needs to break out into additional tabs, named after firstly the country, then customer name. Can we limit it to max fifteen characters country name and max ten characters customer name, with an auto " - " in between?
i.e. - this should create 6 tabs - labelled:
England - David, France - Tom, France - Fred, Germany - Matthew, USA - Michael, USA - Fred
Can anyone help?
Thank you
Tina
Bookmarks