I have a spreadsheet with data in columns A-K.
Row 1 is always the header but their are varying numbers of row
depending on the original source data (which comes from an externa
database)
Column J contains employee names (each employee name is in a continuou
range but this range is never static). There can be anything from 1-3
names listed in Column J and each name can have any number of rows.
What I want to do is for each name (apart from the first range) to cu
and paste the range into a new worksheet and delete any empt
worksheets.

So if column J had this

Jack
Jack
Bob
Bob
Bob
Tim
Tim
Tim
Tim

I want to leave all the data for Jack in the original sheet and cut an
paste all of Bob to sheet2 and Tim to sheet3 and so on. Row 1 should b
copied to each sheet also so actual data starts in row2 for each sheet
This eaxmple would then have a workbook with 3 sheets. If I had a fourt
name in Column J then it would have 4 sheets
I already worked out a macro to rename sheets based on the value in J
and to insert totals on each sheet but am currently manually cuttin
and pasting.

Thanks for your help
Phi

--
Message posted from http://www.ExcelForum.com