Hi,

I did a similar macro to copy records from main sheet, to various
other sheets, following a criteria. And also did the sub total by
itself. If you face any other problem, do let me know.

Sharad