move data to new sheets with same name
Posted on 2014-08-01
from my active sheet I need to move data to a new sheet that has the same name as the name in column J [Ref]
so Rows go from A to S and I need all data from activesheet for CLOVC to be put on Sheet Named ClOVC, all data for BKIDQ to be put on sheet named BKIDQ etc etc
Thanks in Advance.