Marvellous ! Many thanks for the sample. I'm going to enjoy learning how
your sub gets it all done. Cheers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Sure, I've used the original file with extra features (like formatting
borders on cells and hiding rows on some sheets) still in it. I've
obscured
the data that was in it originally, so that should provide anonymity. You
can get the file he
http://www.jlathamsite.com/uploads/M...mnContents.xls

It moves data from the one sheet based on contents of column E. If a
needed
sheet does not exist, it is created, so when you run the macro, several
sheets will be added to the workbook.