Guys,

I have a sheet of data, with many lines, that I want to seperate out onto
individual tabs within the same workbook, and to re-name those tabs.

ie within the master sheet their will be data for Area1, Area2, Area3 etc and
what I need is Sheet1 = Area1 - tab re-named Area1, Sheet2 = Area2 - tab re-
named to Area2 and so on.

Anybody know how to write the code to do this??

Many thanks for any help

Kind Regards

David

--
Message posted via http://www.officekb.com