hi
I have one long list dloaded from Sage.. now in Excel 2003.
Columns A-E are populated.
I need some VBA that will look down column A ( which contains supplier names) and every time it comes across a "new/diff" one I want it to cut that data for that supplier and put it in a new sheet and also name the tab the same as the supplier , essentially leaving me with multiple tabs with each supplier's data in it alone.
The data is already sorted by column A ( supplier name)
ta