Okay, I am not quite sure to explain this, but here goes:
When I run this marco
It takes the range 2 - 6 and across filled with data.
It exports the files as Title 01.xls.
The name is obtained from the A1
Then same happens for Title 02 and all the USED rage beneath it.
The VBA look for one...